How to sort the period

[Elan]

I need to sort either period or period startdate in the correct flow

for example -- if i had jun14, jul15,apr12, jan11 -- i need to sort and show in my dashboard like jan11,apr12,jun14,jul12

can u suggest any idea to resolve this

[marcus_sommer]

Don't load them as strings else as numeric values, maybe like:

date(date#(FinPeriod, 'MMMYY'), 'MMMYY') 

- Marcus