Absolute Value Sort in Straight Table

[asknyldz]

Hi there,

How can i Absolute Value Sort my values in Straight Table.

This is should be below,

2012     2000

2013     -1500

2011     1000

You can find attached sample file.

[swuehl]

Have you tried a sort expression on sort tab:

=fabs( YourTableExpression )

?

[asknyldz]

Dear Stefan,

Sorry i didn't success my original dashboard. You can find attached, maybe you can help with this.

[swuehl]

You are using multiple dimensions, so only sorting one dimension would not return the desired result.

I've added a  hidden dimension that is a combination of all used dimensions, i.e. a primary key to your table.

Not all your dimensional rows show results for both forecasted periods, that could also be a problem when sorting only on one expression. I've changed the sort expression to use your third column.

See attached.

[swuehl · Accepted solution]

It might be even possible and more simple to create another expression:

=Fabs("vs Last Forecast")

and use this expression to sort your table (column could also be hidden on presentation tab).

[asknyldz]

Amazing!

Thanks