Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
For average, you can use like this,
=Sum(Sales)/Sum(total Sales)
Single dimension only r u using?