Pivot Table Calculations

Sunclipse

New Member
Joined
Aug 31, 2006
Messages
13
Is it possible to add a calculated formula that divides into a grand total given by the pivot table?

Ex:

I have the Revenue generated by each product in a list. Can I add a row that will show the percentage of total revenue and change accordingly as I pivot the table?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Reid

Well-known Member
Joined
Oct 29, 2004
Messages
593
Right click on the data field and choose "Field Settings." Then click on the "Options" button to expand the dialog box. In the "Show data as" drop down box, choose "% of column" or "% of row" as appropriate. Note that you can also drag the same field into the data area twice, then have one column with the actual number and the other with the percent:
Book5
ABCDE
11
12Data
13ProductSumofRevenue2SumofRevenue
14a10010.00%
15b20020.00%
16c30030.00%
17d40040.00%
18GrandTotal1000100.00%
19
20
Sheet1


Hope this helps.
 

Forum statistics

Threads
1,141,728
Messages
5,708,130
Members
421,548
Latest member
douae

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top