Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone I have a database with the number of total sales for each month, for year 2018. How can I calculate the evolution from one month to another in percentage (example: from May to June is a growth with 3.2%). Thank you very much!
What kind of chart are you using? Is it a pivot table or straight table? Are you using MonthYear or Month as one of your dimension? If you are... you need to use Inter-Record Functions such as Above/Below for Straight table or After/Before for pivot table where Month or MonthYear is a pivoted dimension. You can also use The As-Of Table which need some script modifications.
If Month or MonthYear is not a dimension, then you can use set analysis to do this