1 Reply Latest reply: Sep 4, 2012 2:14 PM by mayilvahanan ramasamy RSS

    calculate diference between dimension records.

      Hi,

       

      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.

       

      Att,

      Jorge