Sorting changes when selection is made

[Anonymous]

H All,

I have a list of months, that serves the user as a filter to slice define the report,

the field is sorted by an ascending numerical represntation of the month name, e.g. 012015, 022015, etc. (**details on sorting below)

When the user makes a choice and marks a specific month, the sorting order is changed to show the selected month on the top,

can i make it static? I believe it's confuzing the user!

** I attached 2 screenshots: a sample of the sorted simension & it's definition in Sort tab

Thanks in advance,

Nir

[arulsettu · Accepted solution]

may be this

in sort tab -> expression    

MinString({1} monthfield)

[tresesco]

Write sort expression like:  =Only({1} [Billing Month Num])

[tyagishaila]

try,

Sort--> Load Order -> Ascending

deselect rest check boxes.

[#5]

i was looking for the same answer in another post , your answered helped me

thanks

[Anonymous]

Both options works well

Thanks pro's