PIVOT TABLE PERCENT OF TOTAL

[CCZAJKA]

Hi!

I just created a pivot table that has about 30 subtotals and one grand total. I want to run a percent of total calculation based on the subtotals, not the grand total. I didn't want to do this in excel because then I would have to create $A$A for every subtotal, it just seems it should be easier based on a pivot, but maybe it can't be done. Thanks for your help!!

 

[Datsmart]

Take a look at this Demo for Calculation fields in a Pivot Table
http://www.datapigtechnologies.com/flashfiles/pivot4.html

It should help you with your percent question.

 

[salemnj1]

that's a great tutorial, but it still doesn't realy show how to get a % of Subtotal...