Skip to Content
0
Former Member
Sep 23, 2009 at 06:48 PM

BEX Web Query and Sort Key Figure Column Descending instead of Ascending

345 Views

I need to sort a key figure, such as gross margin descending instead of the default ascending. I know the user can select the column and right click to sort, but the requirement is to sort the results descending on initial display of the query results.

From what I had read, it seems you can only control sorting on characteristics in query designer and not key figures, but I was wondering if anyone else may have figured this out as users are annoyed having to change sort for every query from ascending to descending. I have also looked at WAD for template 0 analysis_pattern, but there does not appear to be any properties to define the default sort order for result columns.

Thanks for any help you can offer

Lee Lewis