Month year sorting order

[abc_18]

Hi,

I have a list box for month year field in my report.

whenever I click on any particular month say 'Jan-2017' then rest of the month data is not appearing in sorting order.

I have already applied below formula

Dual(MonthYear,match(MonthYear ,'Nov-2016','Jan-2017','Feb-2017','Mar-2017','Apr-2017','May-2017','Jun-2017','Jul-2017','Aug-2017','Sep-2017','Oct-2017','Nov-2017','Dec-2017'))

after applying this formula initially its displaying in sorting order only, but after any particular month selection order is getting changed.

[its_anandrjs]

In Sort order try with

Only(MonthYear,match(MonthYear ,'Nov-2016','Jan-2017','Feb-2017','Mar-2017','Apr-2017','May-2017','Jun-2017','Jul-2017','Aug-2017','Sep-2017','Oct-2017','Nov-2017','Dec-2017'))

Or

Only(match(MonthYear ,'Nov-2016','Jan-2017','Feb-2017','Mar-2017','Apr-2017','May-2017','Jun-2017','Jul-2017','Aug-2017','Sep-2017','Oct-2017','Nov-2017','Dec-2017')

[Anil_Babu_Samineni]

May be Use Only() in your statement?

[abc_18]

I tried using this expression, but still on selection of any particular month order is getting changed.

[its_anandrjs]

In your load script add one table with SortOrder field which contains the numeric value in increasing order for monthnames and the Month Year field should be exactly same with your Fact table.

MonthSortOrder

Load * Inline

[

MonthYear,SortOrder

Nov-2016,1

Jan-2017,2

Feb-2017,3

Mar-2017,4

Apr-2017,5

May-2017,6

Jun-2017,7

Jul-2017,8

Aug-2017,9

Sep-2017,10

Oct-2017,11

Nov-2017,12

Dec-2017,13

];

After this in the Sorting of the field properties use this field SortOrder

[tresesco · Accepted solution]

To avoid the selection re-ordering, try using set analysis {1} like:

Only( {1} Match(....

[abc_18]

Thanks a lot Tresesco...very helpful