Hello, I'm trying to add some "percentage of total column" to my data and I was wondering what is the best way to do this. I have a table looking like this: April SalesMay SalesJun SalesJuly SalesStore 1120 220200230Store 2150135120200Store 315070120140Store 48065100120Total500490540690 And I would like to get some output like this: April Sales% of totalMay Sales% of totalJun Sales% of totalJuly Sales% of totalStore 1120 24%22045%20037%23033%Store 215030%13528%12022%20029%Store 315030%7014%12022%14020%Store 48016%6513%10019%12017%Total500 490 540 690 Is it possible to have a generic formula/tool to do this? The months often change so the column names are not always the same. Thanks in advance.

Create columns with percentage of total

Hello,

I'm trying to add some "percentage of total column" to my data and I was wondering what is the best way to do this.

I have a table looking like this:

	April Sales	May Sales	Jun Sales	July Sales
Store 1	120	220	200	230
Store 2	150	135	120	200
Store 3	150	70	120	140
Store 4	80	65	100	120
Total	500	490	540	690

And I would like to get some output like this:

	April Sales	% of total	May Sales	% of total	Jun Sales	% of total	July Sales	% of total
Store 1	120	24%	220	45%	200	37%	230	33%
Store 2	150	30%	135	28%	120	22%	200	29%
Store 3	150	30%	70	14%	120	22%	140	20%
Store 4	80	16%	65	13%	100	19%	120	17%
Total	500		490		540		690

Is it possible to have a generic formula/tool to do this? The months often change so the column names are not always the same.

Thanks in advance.

Common Use Cases

Accepted answers

nick_ceneviva

The attached workflow should do the trick and provide the flexibility to handle the columns name changing regularly. It uses the transpose tool to get the data in a format that is easy to calculate the Percent of Total and then the cross tab tool to get the data back to the desired state.