Thursday, August 23, 2012

How to order an Attribute in a custom fashion


I have a Month attribute which has only a desc form having values Jan, Feb, mar...These months are not getting properly ordered in the report from Jan to Dec. How to achieve this?


Add the grid to the dashboard. Double click the grid and perform custom sorting by right clicking on the attribute->Sort option (based on MSTR version)

Create another form for the attribute with the following expression

ApplySimple("case when  #='Jan' then 1 when #2='Feb' then 2 when #3='Mar' then 4....
when #0='Dec' then 12 end",Month@ID)

Then in Data->advanced sorting->Sort by the form created.

No comments:

Post a Comment