![]() |
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? |
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