Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort pivot table
Is there a way to sort a pivot table by two fields? I have a field with
Fiscal year and a field with Gross margin %. I want the pivot table sorted by the total gross margin % for the salesman but I do not want FY 2006 to be above FY 2005. By using a Sort by Gross Margin % it is sorting by the Fiscal Year subtotals and not just the total. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort pivot table
Hi,
I am not sure what situation exactly you have, but you can move data also by right clicking on row or column heading data and then select Order and then select move up, down, right, to beginning... In this case you do not have to worry is it ascending or descending order. Regards, Nika Lampe "jbormann" je napisal: Is there a way to sort a pivot table by two fields? I have a field with Fiscal year and a field with Gross margin %. I want the pivot table sorted by the total gross margin % for the salesman but I do not want FY 2006 to be above FY 2005. By using a Sort by Gross Margin % it is sorting by the Fiscal Year subtotals and not just the total. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort pivot table
The row and column headings are in the right order. It is the data under the
column headings I want to sort by Gross Margin and then Fiscal Year. "Nika Lampe" wrote: Hi, I am not sure what situation exactly you have, but you can move data also by right clicking on row or column heading data and then select Order and then select move up, down, right, to beginning... In this case you do not have to worry is it ascending or descending order. Regards, Nika Lampe "jbormann" je napisal: Is there a way to sort a pivot table by two fields? I have a field with Fiscal year and a field with Gross margin %. I want the pivot table sorted by the total gross margin % for the salesman but I do not want FY 2006 to be above FY 2005. By using a Sort by Gross Margin % it is sorting by the Fiscal Year subtotals and not just the total. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort function on Pivot Table | Excel Worksheet Functions | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
how do i automatically sort data in a pivot table | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |