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.



      vYearSel_1 is just a variable for the previous year


      Does anyone know why this will not work?


      Appreciate any help!