ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I move rows in a pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/14792-how-do-i-move-rows-pivot-table.html)

Tiff

How do I move rows in a pivot table?
 
I have a pivot table and the total is at the bottom of the table. I am
wanting to start the table with the total. How would I do this?

CyberTaz

Please provide more info re version and other details pertinent to your
question. Replies often vary from one to another.|:)

"Tiff" wrote:

I have a pivot table and the total is at the bottom of the table. I am
wanting to start the table with the total. How would I do this?


Debra Dalgleish

You can change the layout so the subtotals are at the top of a group,
but the grand totals can't be moved from the right side or bottom of the
pivot table.


Tiff wrote:
I have a pivot table and the total is at the bottom of the table. I am
wanting to start the table with the total. How would I do this?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 08:03 AM.

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