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