9 Replies Latest reply: Jul 15, 2013 1:02 PM by Michael Solomovich RSS

    Error in Calculated Dimension with AGGR function

    Callum Sparrowhawk

      I'm trying to implement a calculated dimension into a chart using an AGGR function.

       

      I have a list of total revenue for different products, and I want to group them to see what proportions of the products fall into each group.

       

      Below is the code I am trying to use to calculate the dimension.

      =if(sum(aggr(sum({$<Year={$(vYearSel_1)}ActualRevenue),Product))>100000,'>100k',
          
      if(sum(aggr(sum({$<Year={$(vYearSel_1)}ActualRevenue),Product))>200000,'>200k','Other'))

       

      vYearSel_1 is just a variable for the previous year

       

      Does anyone know why this will not work?

       

      Appreciate any help!