Pivot table not sorting
 

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.

Pivot table not sorting
 

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?

--
Regards
Roger Govier

"nathan_savidge" wrote in message
...
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.

Pivot table not sorting
 

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.

"Roger Govier" wrote:

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?

--
Regards
Roger Govier

"nathan_savidge" wrote in message
...
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.