Sort a chart Dimension by two specific values first and then take the rest as it is from the Dimension field? [Example provided]

[jblomqvist]

Hi all,

I have a Bar chart with following Dimension values in the Useful Life dimension field.

In there I would like to sort by values:

<<<Blank>>>

<1

and then the rest of the values from the dimension field.

I would like to ensure the first bar is <<<Blank>>> followed by <1, and then the rest of the order is by values in the Useful Life field. The rest of the values are numberic so it could be 5, 7, 12. 13, 21 etc.

How can I do this?

I tried using the Match fun like Match(Useful Life, '<<<Blank>>>, '<1', Useful Life) but it did not work.

Any suggestions?

[tresesco]

In the sort tab, enable both Expression and Numeric Value. PFA

[marcus_sommer]

Maybe in this way: if([Useful Life] = '<<<Blank>>>', -1, [Useful Life])

- Marcus