Hi Guys, i have the following PQL Code "TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM" );"I want to sort it by the count values, so that the most frequent value is the first one and the least frequent value is the last one. How can i do tha

Hi Philipp ,

To understand more - where are you creating the PQL , in OLAP table ? I mean are you creating this PQL for a KPI ?

If yes - If you go little down to the same swim lane where you are creating the KPI or Dimension.. You will get the option of sort By --

Please add the column value you want to sort!

Hope this helps..

Please mark my response as best response if this is helpful.

Regards

Ayan

I'm creating it in a query data activity in an action flow and im trying to sort by the result of the code i provided above. The option sort by does not work ln this case. So for example theres a value thats occuring 2 times in the column, one that occurs 4 times and one that occurs 6 times the order should be: 6,4,2. Most occuring item first and least occuring item last.