Pivot Table Soret

S

Steve B

Greetings,

Need help as I can't seem to get my pivot table to Sort. Want to sort by
ascending or descending based on value in total column of data. I try the
Pivot Table/Sort and Top 1 but only seems to give me option to sort the first
column.

Any help or direction is appreciated.

Thank You!
 
G

Gina

On 2007 version, Right click on any of the value in the column that you want
to sort and hover on the sort option. There will be options to sort
ascending/descending and other sort options.
 

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

Sort in a Pivot Table 1
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Pivot Table Counting Text Data 0
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
Pivot Table Sort 0
Cannot sort a table containing text 5
Pivot Table Sort 1

Top