Percentages in Pivotal
EXCEL 2007
In your, "value column" you can right click in the Column Name / Value Field
Settings / Show values as tab / change the Show values as field to % of
column / OK
Not quite what you want.
If my comments have helped please hit Yes.
"JoeM" wrote:
I have a pivot table I want to do percentage of total on:
Column 1 Column2
Ice Cream 32
Cake 50
Total 82
I want to add a third column that says 32 is 39% of the total 82. And 50 is
61% of the total. The system should be able to calculate this.
I tried to do a search but couldn't get anything to come back.
|