C
carolini
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!!
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!!