Pivot table not sorting

  • Thread starter Thread starter nathan_savidge
  • Start date Start date
N

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.
 
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?
 
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.
 
Back
Top