1 Reply Latest reply: Sep 4, 2012 2:14 PM by Mayil Vahanan Ramasamy RSS

    calculate diference between dimension records.



      I need some one´s help for the following scenario:


      For a table with, Month as a dimension and a expression sum(Sales), how can I calculate the sales percentage evolution average per month?

      For that I need to pick the current month(dimension) and sales record and the previous month(dimension) and sales record. Iam not sure if I may have to do it on the script before load or if there is a way to put in a expression?


      I really appreciate your help.