Custom Sort order in pivot table

  • Thread starter Thread starter jeff
  • Start date Start date
J

jeff

Hi, Peter,

The only way I could fool Excel into sorting 'All other'
to last was to place a white-font-colored 'Z' in front
making 'ZAll other' - the Z is invisible.

There has to be a more logical way, however..

jeff
-----Original Message-----
I have built a pivot table and have it sorted in market
Click to expand...
share order. However, I have an "All other" category
which has a significant percentage, but I want it to
always appear last irrespective of its percentage order.
How do I get it to appear last?
 
Jeff

I figured it out, you have to turn off the auto sort, move the desired row to the end using a sort command (move to end) then do a data sort command with all the other rows (exlcuding the one you want last.)
 
You must log in or register to reply here.

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 Sort Order 1
Pivot Table- Column 2 sort 3
Pivot Table sort -Excel 2007 4
Pivot Table Data Column Sort Excel 2007 1
Pivot Table sorting 1
Pivot Table Sort Error 2
Pivot Table Report Filter Sorting 3
Sort order not being matched in pivot table 2

Back
Top