| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a Pivot Table | Excel Worksheet Functions | |||
| Pivot Table Sorting | Excel Worksheet Functions | |||
| pivot table sorting | Excel Worksheet Functions | |||
| Pivot Table sorting | Excel Discussion (Misc queries) | |||
| Need help sorting pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
