Pivot Table sorting

S

Soccer boy

I was wondering if there was a way to turn off the pivot table sorting, it
sorts all of my categories in columns into Alphabetical order and i would
like to sort my data in non-alphabetical order. is there a way to do this?
Example:
This is what i want: What it is giving me:
SAG Line 1 Concentrator Availability
SAG Line 2 HPGR
SAG Line 3 P80 Value
HPGR SAG Line 1
P80 Value SAG Line 2
Specific Gravity SAG Line 3
Concentrator Availability Specific Gravity
 
D

Debra Dalgleish

You can manually sort the list in the pivot table:
Select one or more adjacent items in the list of categories
Point to the border of the selected range
Drag the selected range up or down in the list of categories
 

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

Top