Aggr Sorting RowNo(Total)

[Rambo]

Hi Community,

I'm trying to sort an AGGR expression without success. Please see if you can help me out.

Would highly appreciate any alternate solutions too please (not from script please as I have some dynamic frontend calculations)!

Aggr(nodistinct RowNo(TOTAL),Name,(Id,(NUMERIC,ASCENDING)))

Regards,

Rambo

[QFabian]

Hi @Rambo , did you try using the chart order ?

[brijesh1991 · Accepted solution]

Instead of RowNo, go with rank function please.

num(rank(max("KPI Value"),4))

[Rambo]

Thank you; this works! Appreciated.

[Rambo]

Not working as expected as this will change my dimension order which I do not want.