Move Grand Total Fields in a Pivot Table

I want to show the Account Charges fields and their Grand Total and then the Account Count fields and their Grand Totals, reading from left to right.  In other words, I need to move the Grand Total of Account Charges leftward from its present location near the far right-hand side of the screen to display in between the Account Charges fields and the Account Count fields.  Please advise.

Clicking on the columns does not display a movement symbol as some of the web-based guides have suggested.

Doug in Y

October 4th, 2013 9:35am

I'm afraid that there is no setting for you to move Grand total from right to left directly.

You need to add the Grand Total field in your source data or you can insert a calculated item in pivot table as a workaround.Here is a site you can refer to: http://www.contextures.com/xlPivot13.html

Free Windows Admin Tool Kit Click here and download it now
October 7th, 2013 10:47pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics