Skip to Content
avatar image
Former Member

Sorting not working in Dimension Filter

Hi All,

I am using Universe as the source based on HANA.
I want to sort months according to financial year and use that in Dimension Filter.
By default Month object was coming in random order so I created an object in the universe as

Case

When Month='APR' Then 1

When Month='MAY' Then 2

.

.

When Month='MAR' Then 12

End

I sorted the Month using this object,

Now this Month object is sorted when I see that in the Initial View but in dashboard it is not.

Screenshots attached.

Any inputs will be appreciated.

sortingdashboard.pngsorting-initialview.png

Regards,
Piyush

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 11, 2017 at 09:15 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2017 at 09:42 AM

    Hi Tammy,

    Unfortunately that is not related to my scenario.

    Regards,
    Piyush

    Add comment
    10|10000 characters needed characters exceeded