View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lynn
 
Posts: n/a
Default Pivot Table % of Totals

I am using pivot tables to summarize sales by marketing initiatives over a
number of years. The totals are working fine.

I would like to add a % of Grand total column ONLY at the right side of my
pivot table. When I add my summary field & change the option to % of Total I
get the calculation for all levels of detail. It is way to busy. How do I get
this only for the right side of the table?