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.

[tolgaclk]

Hello,

How do I formulate the order I specified in the table below?

COD	ID	ORDER
234234	ENGİN	1
23423	ENGİN	2
4235	MESUT	1
123412	CENGİZ	1
1423	SEDAT	1
436	SEDAT	2
67	SEDAT	3
56856	NURETTİN	1
78	HASAN	1
4563423	SEBAHATTİN	1
235	IŞIK GIDA	1
6546	ABDULKADİR	1
578	ABDULKADİR	2
578567434	ABDULKADİR	3
34564	ABDULKADİR	4
56879685	ABDULKADİR	5
3546352	ENGİN	3
567476	ENGİN	4
967857	ENGİN	5
568567	NURETTİN	2