Pivot table not sorting

[nathan_savidge]

Hi,

I have a pivot table that is not sorting on the field that i want it to.

I have my data set to dtRec'd (field for sorting) as descending and the
pivot field set to descending, but it still doesnt work.

Can anyone help.

Thanks

Nathan.

 

[Roger Govier]

Hi

Are the Dates true Excel dates, or Text dates?
When you say it isn't working, what do you mean? What order do you get?

 

[nathan_savidge]

Hi,

I have fixed now, by moving the date column to the first column and it
works, but it didnt when the date was the 2nd column.

I will also check the dates.

TIA

Nathan.