Force sort order display for CalendarMonth dimension

[bullish35]

I have a chart which compares data between two time periods and displays the data based on calendar month. The sort always begins with January, but I want it to begin with December. Next month, the start month should be January, then February, etc. Is this possible?

Prior Period = 12/1/08 - 11/30/09

Current Period = 12/1/09 - 11/30/10

Thank you

[#2]

You should be able to use Sort By Expression and use your Date field. You want this sort to be applied to your Month dimension.

So, on the Sort tab, for your Month dimension, uncheck everything except Expression. Then in the expression box, enter the name of your Date field. Your December values will come before your January values.

[bullish35]

Hello. Thank you for your response. I have tried to apply your suggestion, but I have not achieved the desired results. I am uploading a sample version of the QVW I am working with. The Previous Period is set to = 11/1/2008 thru 10/31/2009, and the Current Period is set to = 11/1/2009 thru 10/31/2010. The sort expression in the Paid ACP object is set as you suggested (assuming I interprested your recommendation correctly).

Any idea why this may not be working?

[#4 · Accepted solution]

I looked at your sample and Max(CalendarDate) seemed to work for the sort expression. I also set it to Ascending and Feb was first.

[bullish35]

Thank you! I had to make some changes to my Master Calendar, so that the min and max dates reflected the range for my chart, then your solution worked exactly as needed.