| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sorting data in Pivot Tables
I have Excel2000 and would like to be able to sort the data elements in the
Row section of the pivot table in the order I choose. For example, if I have 3 elements such as Apple, Orange, Cranberry and want them to show in the pivot in this order I have to name them in the dataset as A. Apple, B. Orange, C. Cranberry and sort them ascending. Is there a way to do this without having to stick the A, B, C in front of the data item? Thx |
|
#2
|
|||
|
|||
|
Presumably now the headers show Apple, Cranberry and Orange. Just select the
cell containing the header "Cranberry" and type Orange. You can put them in any order you want with this technic. On Mon, 17 Jan 2005 14:13:02 -0800, "gramos14" wrote: I have Excel2000 and would like to be able to sort the data elements in the Row section of the pivot table in the order I choose. For example, if I have 3 elements such as Apple, Orange, Cranberry and want them to show in the pivot in this order I have to name them in the dataset as A. Apple, B. Orange, C. Cranberry and sort them ascending. Is there a way to do this without having to stick the A, B, C in front of the data item? Thx |
|
#3
|
|||
|
|||
|
That worked beautifully. Thanks!
"Myrna Larson" wrote: Presumably now the headers show Apple, Cranberry and Orange. Just select the cell containing the header "Cranberry" and type Orange. You can put them in any order you want with this technic. On Mon, 17 Jan 2005 14:13:02 -0800, "gramos14" wrote: I have Excel2000 and would like to be able to sort the data elements in the Row section of the pivot table in the order I choose. For example, if I have 3 elements such as Apple, Orange, Cranberry and want them to show in the pivot in this order I have to name them in the dataset as A. Apple, B. Orange, C. Cranberry and sort them ascending. Is there a way to do this without having to stick the A, B, C in front of the data item? Thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables filtering data | Excel Discussion (Misc queries) | |||
| Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
| Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
| Pivot Tables referring to external data query | Excel Discussion (Misc queries) | |||
| Help with pivot charts and data labels | Charts and Charting in Excel | |||
Linear Mode
