Sort months in filter control by key

[Former Member]

Hi,

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.

[TammyPowlas]

Could you try Gil’s suggestion here https://archive.sap.com/discussions/thread/3420653

[Former Member]

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.