View Single Post
  #1  
Old April 22nd, 2010, 07:16 PM posted to microsoft.public.excel.worksheet.functions
JoeM
external usenet poster
 
Posts: 41
Default Percentages in Pivotal

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.