5 Replies Latest reply: Jan 16, 2018 4:17 AM by Sunny Talwar RSS

    Nested Aggregation not allowed - Error

    Balaji SJ

      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.