Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |