This is a repost of an advanced Pivot Table question
Posted by Paul Johnson on December 12, 2001 6:15 AM
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)
Mark repsonded with - Use % Of with 'Region' as you Base field and "Central" as your Base item (nt) - Mark W. 14:03:38 12/10/01 (0)
You help is appreciated...e-mailed responses are appreciated.
This works for just one item - But - What if I want to show the percentage of total for all of the items as opposed to the quantity.
Thanks again for your help..... PJ