| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort data in data area in a pivot table
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort data in data area in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Data Area | Excel Discussion (Misc queries) | |||
| text in data area on pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table: Custom formula in data area | Excel Discussion (Misc queries) | |||
| Data Area of Pivot Table and Pivot Charts | Charts and Charting in Excel | |||
Threaded Mode
