Pivot Table Sort

  • Thread starter Excel Pivot Table Custom Sort
  • Start date
E

Excel Pivot Table Custom Sort

I have a Pivot table that has the total for each item for the years 2003 and 2004 side by side. I need to control the sort to only sort for the year 2004 and 2003 won't be affected. I have a margin % I need in ascending order, but only for 2004. Is this VB code or a macro that needs to be written?

I understand how you go to the advanced area in field settings for this, but I need this exception for my sort.
 

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

Dealing with a Pivot Table (when I don't want to) 0
Sorting the pivot table field list 4
Sorting Cube dimension names in a Pivot Table 0
Pivot table 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
In Pivot table sort 1
Sorting & pivot table 1
Sorting Ascending Subgroup in a Pivot Tables - 2007 0

Top