pivot table, strange sort order?

[dlorenc]

Pivot is to report by Management Lead; their projects; the project deliverables; deliverable start date; deliverable end date... sorted by deliverable end date (to answer the question, when will I get my deliverable).

Currently I have an ascending sort on Managment Lead and planned end date...and it works great .. kinna... the DISPLAY order curently has Planned end date before planned start date (left to right)...but visually, you typically would read start data then end date (left to right)... IF I move end date after start date, the sort is screwed up... in that the sort restarts with the change in start date...

for example:

MgmtLead ProjectTitle MilestoneStart MilestoneEnd MilestoneTitle
Doug Project1 6/28/10 6/30/11 MS1
9/30/11 MS2
4/01/12 MS3
6/07/10 1/31/12 MS4

It works fine if I move MilestoneEnd before MilestoneStart:

MgmtLead ProjectTitle MilestoneEnd MilestoneStart MilestoneTitle
Doug Project1 6/30/11 6/28/10 MS1
9/30/11 6/28/10 MS2
1/31/12 6/07/10 MS4
4/01/12 6/28/10 MS3

?????????????

 

[Weaver]

This might be caused by alphanumeric sorting - the E of Planned end date occurs before the S of Planned Start date in the alphabet. You might be able to spoof it by inserting a space in front of Start date (character 32, the space, would sort before character 69 E)

 

[dlorenc]

nope..same effect..I also tried changing the E in EndDate to X... same issue..

i dont quite understand how the field titles affect the sort of the dates under the field...but I tried your suggestion... and appreaciate your time and advice.

this one is a bit weird to me...