Sorting of Months

[montubhardwaj]

Hi All,

I have a problem with sorting of Months (used as Dimension). The Months are of Current Quarter and are Dynamic i.e. in Quarter 4, Month on the Dimension axis will be Oct-10, Nov-10, and Dec-10.

Everything is working fine except that the Month are not sorted Properly. I tried many ways but no luck [:'(]

Please see below for the problem. Many thanks in advance.

Regards,

Sharma

[#2 · Accepted solution]

Hi Sharma,


I just don't have enough time to test it, but something like:

=if(Per_Quarter=$(CurrentQtr),date(makedate(1,Month,CurrentYear),MMM-YYYY))

should bring your result.

Regards
Martin

[montubhardwaj]

Hi Martin,

Finally... I got it

I wrote Dimension something like this and is working perfectly.

=if(Per_Quarter=$(CurrentQtr),date(makedate($(CurrentYear),Month),'MMM-YY'))

Also see the below snapshot of output:

Thank You all for sharing your thoughts.

Cheers,

Sharma