Hi

I run WinXP with Excel2000

I have a table with about 70 lines of data. I have created a pivot table for
the data (only 2 data columns and a total column)

I would like to have the 2nd column in the pivot table sorted.

I right click on the 2nd column header of the pivot table and select "field
settings"
I then select the "advanced" tab
I click the Auto Sort option to ascending

However, it does not sort the data. I have tried it descending and it is the
same result

What am I doing wrong?


Thanks

John