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.