Growth Function

Here is an example:

If you have data:

Month, Sell, Year

1,10,2018

2,20,2018

3,30,2018

4,40,2017

And you would like to calculate the Sell growth month-to-month for the year, you can do:

select * order by Year, Month;

select Year, Month, concat(growth(Sell, Year),"%") as growth

The result should be like this:

0 comments

Please sign in to leave a comment.