Sorting pivot table by specific field (column)

W

Wesslan

Hey guys (and girls),

Anyone know how to sort a pivot table by a specific field (not the
total sum of the fields)?

For instance, if I have 5 years of data 2002-6 and 20 countries. If I
make a pivot table of these I get 21 rows (the countries + total) and
6 columns for years (5 years of data + total). If I use the Field
Settings --> Advanced --> Sort by field the Pivot table (PT) will be
sorted by the sum of the different fields. What if I don't want this,
but rater want to sort it by for instance year 2003. How do I do that?

Anyone have a nice and clever solution? Much appreciated!
 

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 calculated field Count(field) / sum(field) 0
pivot table calculated field 1
sorting pivot table by sorts by "show value as" 1
Pivot table report invalid 0
Pivot Table Grand Total Issue 3
Sum Unique Values in a Pivot Table 1
Excel 2007 issue...Urgent 1
Custom Field on Pivot Table? 1

Top