Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In my source data I have a list of clients in the rows and then figures in
columns under Quarter 1, Quarter 2, Quarter 3 and Quarter 4. I create a PivotTable for this and I want the Quarters sorted in this order, I would just like to be able to put Quarter 4 on top on occasion. Would a custom list do this? How does one create a Custom list/sort do this in a PivotTable? Thanks for any help. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Kokomojo wrote:
In my source data I have a list of clients in the rows and then figures in columns under Quarter 1, Quarter 2, Quarter 3 and Quarter 4. I create a PivotTable for this and I want the Quarters sorted in this order, I would just like to be able to put Quarter 4 on top on occasion. Would a custom list do this? How does one create a Custom list/sort do this in a PivotTable? Thanks for any help. The easiest way is to right click the category label (Quarter 4) | Order | Move to Beginning. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you. This answered my question.
"smartin" wrote: Kokomojo wrote: In my source data I have a list of clients in the rows and then figures in columns under Quarter 1, Quarter 2, Quarter 3 and Quarter 4. I create a PivotTable for this and I want the Quarters sorted in this order, I would just like to be able to put Quarter 4 on top on occasion. Would a custom list do this? How does one create a Custom list/sort do this in a PivotTable? Thanks for any help. The easiest way is to right click the category label (Quarter 4) | Order | Move to Beginning. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum by different sorts | Excel Discussion (Misc queries) | |||
PivotTables | Excel Discussion (Misc queries) | |||
PivotTables | Excel Discussion (Misc queries) | |||
Sorts | Excel Worksheet Functions | |||
New to Pivottables- need help | Charts and Charting in Excel |