Nested Aggregation not allowed - Error

[balajisj30]

Hello People

I want to sort Sum(revenue)/Sum(census) based on expression. I have written the below expression in the sorting pane.

Sum({<id_description = {"=Rank(Sum(revenue)/Sum(census))<=10"}>} Sum(revenue)/Sum(census))

But i get an error as (Nested Aggregation not allowed). Please help me to solve this issue.

Thanks

Balaji

[agigliotti]

in which way you'd like to order the output?

[devarasu07]

Hi,

You can try with sortable aggregation method (this feature available Qv12 & above version)

The sortable Aggr function is finally here!

Aggr(Sum({$<id_description = {"=Rank(Sum(revenue)/Sum(census),4)<=10"}>} revenue/census),

( id_description, (=Sum({<id_description>} revenue/census), DESC)))

Thanks,Deva

[balajisj30]

Sort based on values of [Sum(revenue)/Sum(census)] - desending.

[agigliotti]

which chart object are you using to sort as requested ?

[sunny_talwar]

Try this

Sum({<id_description = {"=Rank(Sum(revenue)/Sum(census))<=10"}>}revenue)/Sum({<id_description = {"=Rank(Sum(revenue)/Sum(census))<=10"}>}census)