Sorting in stackbar and/or cross table TOP 10 and "Other"

[Kai Lattmann]

Hello,

I made a cross table and an stackbar, with a Top 10 ranking and a group over 10, withe the following expression:

If(DenseRank(Sum([balance]) OVER ([Countries]),"desc")

[Alain Martens]

Hi Kai,

It's possible to specify a custom sort order for a column. To do so go to the column properties menu if you're working with the Spotfire Analyst client and select the 'sort order' tab after you've selected the right column. There you have the option to configure a custom sort order which allows you to specify 'Other' to be shown last.

Best regards,

Alain Martens