SAP Analytics Cloud: double sorting (measure and dimension) in tables

[former_member777813]

Hi experts,

do you know if it is possible to apply a double sorting in tables (by a dimension and a measure)?

I have the following table in which I want to sort descending by AMOUNT but placing as last value "Other".

If I apply a custom sorting for Calculated Dimension 1 then sorting by amount is cancelled.

I think it could be possibile creating a calculated dimension like this:

= If [Calculated Dimension 1] = "Other" Then 99 Otherwise Rank([AMOUNT])

The problem is that Rank() function is available only in table calculations and it is not possible to create a measured-based calculation (table calculations can not be sorted).

Can you please help me?

Thanks.

[former_member777813]

I solved this issue creating the following calculation:

= If [Calculated Dimension 1] = "Other" Then -9999999 Otherwise [AMOUNT]

Then I added this calculation as a column of the table, I sorted it descending and I hide it.