View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
carolini carolini is offline
external usenet poster
 
Posts: 11
Default Pivot Table Help

I have the below Pivot Table:

Item Jan Feb Grand Total
A 50 50 100
% of A/A&B 50% 50%
B 50 50 100
% of B/A&B 50% 50%

Total A&B 100 100 100

I am adding the formula for % of A/A&B using the Calc Item function. But
when it does not give me the calc result in the Grand Total column.

Can someone let me know what I am doing wrong. thanks!!