Here is an example:
If you have data:
Month, Sell, Year
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:
Please sign in to leave a comment.