Forum

Notifications
Clear all

% of Grand totals

2 Posts
2 Users
0 Reactions
67 Views
(@jayanth-kumar)
Posts: 1
New Member
Topic starter
 

HI, 

Please help me for below query.

1.  How do i insert % of Grand total row wise &  % of Grand total in Column in single pivot table.

2. I have attached below excel file including values for your reference.

 
Posted : 12/12/2020 2:23 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Jayanth,

Please use 'Show Values As' for these calculations. I would provide you with a sample file but my beta version of Excel is crashing when I try to use Show Values As. Yours should be fine though.

Mynda

 
Posted : 12/12/2020 7:24 am
Share: