ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table grand total location (https://www.excelbanter.com/excel-discussion-misc-queries/260157-pivot-table-grand-total-location.html)

Rosemary

Pivot table grand total location
 
Is there a way to show the grand total column in a pivot table next to the
selected fields? Right now, my pivot table shows the grand total in the
right most column of the pivot table

Roger Govier[_8_]

Pivot table grand total location
 
Hi Rosemary

Grand Totals can only appear at the far right or bottom of Pivot Tables
--
Regards
Roger Govier

Rosemary wrote:
Is there a way to show the grand total column in a pivot table next to the
selected fields? Right now, my pivot table shows the grand total in the
right most column of the pivot table



All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com