| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Pivot table sort
I have sales data in a pvot table, columns Year/Month and in rows Customers.
I want to sort the customers by the highest sales dollars specific to each year and not as combined. At present Pivot table only gives data in descending order total sales dollars added for Year 1 and 2. Is it possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Pivot table sort
Hi,
No. The pivot table never allows you to break up a row of data. So for Customer A you can sort by the value in any one year but not by simulataniously by 3 or 4 different years. If you want to sort in the way it sounds like you are asking, you will need to do it outside of the pivot table. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Krish" wrote: I have sales data in a pvot table, columns Year/Month and in rows Customers. I want to sort the customers by the highest sales dollars specific to each year and not as combined. At present Pivot table only gives data in descending order total sales dollars added for Year 1 and 2. Is it possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort in a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Sort | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| Sort in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Hybrid Mode
