calculate diference between dimension records.

[#1]

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

[MayilVahanan]

HI

     For average, you can use like this,

     =Sum(Sales)/Sum(total Sales)

     Single dimension only r u using?