Skip to Content

Sort months in filter control by key

Apr 12 at 10:52 PM


avatar image
Former Member


I'm using Lumira Discovery 2.1 using a BEx query as my source and I've added a filter control for Fiscal period/year(text type) but it's sorted alphabetically (ex. Apr, Aug, Dec, Feb....) .

Is there a way it can be sorted as Jan, Feb, Mar..... ?!

I have a Fiscal period/year key and when I'm in Data View I right click on the key and select sort Ascending and then create the filter control but it's the same, it's not sorting the months as I needed them.

10 |10000 characters needed characters left characters exceeded

Could you try Gil’s suggestion here

Former Member
Tammy Powlas

Thanks, I think that suggestion applies to BOBJ but I've also tried to sort by the compounded key in the data view and nothing.

* Please Login or Register to Answer, Follow or Comment.

0 Answers