hwcarter11
New Member
- Joined
- Sep 19, 2006
- Messages
- 7
I am grouping dates in a pivot table by month and day so users can easily select various ranges, but when I do this the day portion of the date is formatted dd-mmm and sorts incorrectly. I am trying to sort descending on the date field. Any suggestions?
Here is my output. Although I can't seem to get it formatted correctly in the post, I think you can see what it's doing.
Sum of Amount DOW
Months Date Monday Tuesday
Sep 9-Sep
7-Sep
6-Sep
5-Sep $3,407.05
1-Sep
14-Sep
13-Sep
12-Sep $2,337.73
11-Sep $3,637.47
Aug 9-Aug
8-Aug $10,880.04
7-Aug $8,499.01
4-Aug
3-Aug
31-Aug
30-Aug
2-Aug
Here is my output. Although I can't seem to get it formatted correctly in the post, I think you can see what it's doing.
Sum of Amount DOW
Months Date Monday Tuesday
Sep 9-Sep
7-Sep
6-Sep
5-Sep $3,407.05
1-Sep
14-Sep
13-Sep
12-Sep $2,337.73
11-Sep $3,637.47
Aug 9-Aug
8-Aug $10,880.04
7-Aug $8,499.01
4-Aug
3-Aug
31-Aug
30-Aug
2-Aug