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
Excel 2002: How to sort row totals in Pivot Table ? 5
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
Pivot Table Data Column Sort Excel 2007 1
Pivot Table Sort 1
How do I sort pivot table data by subtotals? 2
Pivot Table - Compare Dates & calc. % 1
Sort top 50 in Pivot table 2

Top