Thursday, August 23, 2012

How to order an Attribute in a custom fashion

Question:

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?


Solution:

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)

or 
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