ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   reorganizing a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/104515-reorganizing-pivot-table.html)

hbear

reorganizing a pivot table
 
Is it possible to get excel to display pivot table Grand Totals at the top of
the table, rather than the bottom? I've tried moving them manually, but
receive an error message informing me that I'm not allowed to change part of
a pivot table.
Anyone know of a way to do this?


Bill Ridgeway

reorganizing a pivot table
 
I don't know whether or not the Pivot table header info can be moved.
However, the Pivot table can be treated like any other worksheet. so you
could produce a total at the bottom. Anyway you don't always want to see
the Pivot table header info so those rows can be hidden.

Regards.

Bill Ridgeway
Computer Solutions

"hbear" wrote in message
...
Is it possible to get excel to display pivot table Grand Totals at the top
of
the table, rather than the bottom? I've tried moving them manually, but
receive an error message informing me that I'm not allowed to change part
of
a pivot table.
Anyone know of a way to do this?





All times are GMT +1. The time now is 12:27 AM.

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