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.

       

      Thanks

      Balaji