Sorting on Pivot data (excel 2000)

Topic

New Reply

I may be reading the Help screens incorrectly. I have a pivot table with 2 row fields and 1 column field, with 3 data elements Units, cost and Net book value in the data fields. I want to sort by the Net book value field, but when I look at context menu or Table menus I don’t seem to find out how to do that. Am I incorrect in thinking that that can be done? TYIA

Reply | Quote

Replies

I think that what you need to do is double click on the row field that you want to sort by – probably the left-most one (in my example it is the first visible column, row 15, “sales region”), which will give you the PivotTable Field Dialog – click on the advanced button and you’ll get the PivotTable Field Advanced Options Dialog. Under AutoSort options, change it from “manual” to either descending or ascending and then select the datafield you want to sort by.

Reply | Quote

I think that what you need to do is double click on the row field that you want to sort by – probably the left-most one (in my example it is the first visible column, row 15, “sales region”), which will give you the PivotTable Field Dialog – click on the advanced button and you’ll get the PivotTable Field Advanced Options Dialog. Under AutoSort options, change it from “manual” to either descending or ascending and then select the datafield you want to sort by.

Reply | Quote

This is how to do it in XL97 (I assume your version will be similar):
RIght click on the field name:
Field..
Advanced..
Click on ascending or descending in Autosort options

Steve

Reply | Quote

This is how to do it in XL97 (I assume your version will be similar):
RIght click on the field name:
Field..
Advanced..
Click on ascending or descending in Autosort options

Steve

Reply | Quote