Sort a calculated Dimension in a List Box

[Frédéricdh]

In the List Box, I have a calculated dimension like Week.

I want to choose a value in the dimension but than the order change. How can i keep the order in my calculated Dimension.

I know a solution with Only({1} < dimension> but i don't know the solution for a calculated dimension.

[stevedark · Accepted solution]

HI @Frédéricdh 

Is the behaviour that you are currently seeing that the selected values go to the top of the list box, but you want the selected value to stay where it is?

If so what you need to do is expand the Sorting panel and switch off Auto sorting, then ensure that the Sort By State is not ticked.

If it's not that, perhaps you could post the code for your calculated dimension, as that might have a bearing on how it behaves.

Hope that helps.

Steve