How to sort data in data area in a pivot table

H

Holly

I try to sort the data area, but not the row area in a pivot table.

The sales report is pibot by custmer in sales $. Is there a way to sort the
customer by their sales $, not by letter? Such as the report in the right
side below.

Customer Sales Customer Sales
A $5,000 C $200
B $10,000 A $5,000
C $200 B $10,000
Total $15,200 Total $15,200
 
T

Terry Tipsy

Try this; these are the instructions I found through EXCEL help.

Sort data in the values area
Select a value field in a PivotTable report.
On the Options tab, in the Sort group, do one of the following:
To sort in ascending alphanumeric order, click Sort Smallest to Largest.
To sort in descending alphanumeric order, click Sort Largest to Smallest.
Optionally, to customize the sort operation, on the Options tab, in the Sort
group, click Sort.
In the Sort By Value dialog box, do one or more of the following:

Under Sort options, do one of the following:
To sort numbers in ascending sort order, select Smallest to Largest.
To sort numbers in descending sort order, select Largest to Smallest.
Under Sort direction, do one of the following:
To sort values vertically, select Top to bottom.
To sort values horizontally, select Left to right.
Tip Read the Summary section at the bottom of the dialog box to verify
your choices.
 

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


Top