how do i automatically sort data in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table where I select the product and the customer and the
amount they ordered are displayed. I want the amount of product ordered to
be sorted descending automatically. How do I do that?
 
Double-click on the Product field button
Click the Advanced button
Under Auto-Sort options, select Descending
From the 'Using field' dropdown, select 'Sum of Amount'
 

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

Sorting the pivot table field list 4
In Pivot table sort 1
How to ignore a column of numbers in Grand Total for rows 1
Sorting 2 data columns in Pivot Table 2
Access #Error & Excel Pivot 0
Sort Data Items in Pivot Table 8
Pull data from different worksheets/tab into one Pivot Table 3
Pivot tables 2

Back
Top