Hi there !

I'd like to sort the members of a dimension descending according to their
current tuple values. Also one member should be the last one in the list
whatever tuple value it has.

To be more concrete, the cube contains data from a survey we conducted.
Dimensions are the questions list, the answers list and some selection
questions like age, country or gender. The measure is the count of each
answer to any question for the selected sample.

One question is related to car brands. The results should be sorted with the
most famous brand on top, the least famous at the end, except for the [None
of them] answer, which should always be displayed at the very end.

I am using Analysis manager and Excel.

Thank you for you help.

Vincent