Displaying top 10 by abs value in flat table

[elijahabel]

Hey all,

We have an problem where we need to show the Top 10 values by absolute value, and have the rest grouped into others.

We have been using the chart Limitation option, and setting it to 11, but this shows only the biggest 10 positive values. I know that you can change the expression to use fabs() and it will give us the top 10, but we need the values to still show as negative in their formatting.

Any idea how we can accomplish this? Is there a way to put an expression in the Limitation Expression Editor that could accomplish this?

[dplr-rn]

Use Dual function where you set your display i.e. negative as the text and numerical as fabs.

See below

Dual(text(DummyValue),fabs(DummyValue))

[dplr-rn]

Did it work?