| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how do i automatically sort data in a pivot table
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? |
|
#2
|
|||
|
|||
|
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' Esche wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering data from one pivot table against another | Excel Discussion (Misc queries) | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
| Pivot table data | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
Hybrid Mode
