Sort By Key Figure?

[Former Member]

I am using BEx Query Designer to build a query and I have two key figures. I would like to sort the results by one the ascending values of one of my key figures. The output seems to sort it by the characteristics by default. Is there a way to have the query sorted by key figure values instead?

[Former Member · Accepted solution]

The default sort option by characteristic only. I don't think there is an option to sort by key figure.

However, you can use conditions to display Top N, Botton N, Top %, Bottom % records. For instance you want to show top 10 customer by Sales Amount key figure, crate a condition on sales amount key figure and select the operator TOP N and give the value 10. It will show top 10 customers by sales amount in descending order. I hope this helps.

Edited by: sapwings on Feb 24, 2011 4:53 PM