ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Reversing (https://www.excelbanter.com/excel-discussion-misc-queries/1006-pivot-table-reversing.html)

Neil

Pivot Table Reversing
 
I have a Pivot Table that someone has created for me, which lists some data
chronologically by month which has the earliest months at the left, and
latest at the right.
Is there any way I can reverse the order so that the latest data is at the
right?
I am fairly Excel conversant, although I have never dablled with Pivot
Tables before, also, I know some VBA so a solution along those lines wouldn't
bother me either.

Eagle

You could try a descending sort on the pivot table field concerned.


"Neil" wrote in message
...
I have a Pivot Table that someone has created for me, which lists some data
chronologically by month which has the earliest months at the left, and
latest at the right.
Is there any way I can reverse the order so that the latest data is at the
right?
I am fairly Excel conversant, although I have never dablled with Pivot
Tables before, also, I know some VBA so a solution along those lines
wouldn't
bother me either.





All times are GMT +1. The time now is 11:10 AM.

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