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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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.
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,034
Members
448,543
Latest member
MartinLarkin

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
Back
Top