Sort tree table by absolute values

[kascp]

Hi
Is it possible to sort by absolute values in the tree table? Or is there any easy trick to get this done?
Thanks
Philipp

[tibdex]

Hi Philipp, can you give more details about your use-case and what you want to achieve? A screenshot would help.

[kascp]

Hi
See my screenshot below. This is a simplified example of a tree table I have in my atoti dashboard.
As you can see I sorted the column PROFIT SUM in ascending order (from most negative to most positive number). However, I would like to sort descending by absolute value, i.e. INSTRUMENT 100 should be ranked directly after INSTRUMENT 2.
Thank you
Philipp

[tibdex]

You could create a new measure and sort with it.

m["ABS PROFIT SUM"] = atoti.math.abs(m["PROFIT SUM"])

[kascp]

thank you