I am trying to figure out a way to get a pivot chart to give me a running total as a percentage. I know how to make it give me a running total as a count, but I can't seem to make it do it as a percentage. For example, this is what I would like to do with my pivot table.
Item Count Running Total Running Total Percent
Oranges 25 25 21.19%
Apples 51 76 64.41%
Peaches 21 97 82.20%
Grapes 16 113 95.76%
Bananas 5 118 100.00%
I would like to do this without VBA. Thanks!