Pivot Table advanced question
Posted by Paul Johnson on December 10, 2001 1:56 PM
How can you calculate the % of an item within a Pivot table. The tricky part is that I want a % of the subtotal.
In a past week's tip it was shown how to calculate as a percentage of the whole. But, (using the example) I would like to know the % apples are of Central. (see link below)
You help is appreciated...e-mailed responses are appreciated.
PJ
Posted by Mark W. on December 10, 2001 2:03 PM
Use % Of with 'Region' as you Base field and "Central" as your Base item (nt)
