Sort pivot table

G

Guest

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.
 
G

Guest

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:
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Data Column Sort Excel 2007 1
Pivot Table Variance 2
Add Columns to Right in Pivot Table 1
Pivot Table Question 1
Calculation needed maybe a pivot table - Thank you 2
Pivot Table Calculates the Difference in Grand Total 2
Arranging row titles in a Pivot Table 1
Pivot Table - Quarterly report 1

Top