Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings
Please help to obtain the desired result for calculating ranks.
I would like to rank the products based on the difference of current month and prior month.
(sum({<product= {"=rank(sum(qty), product<=$(vRank)"}, year = 2016 , month = 2 >} qty) )
-
(sum({<product= {"=rank(sum(qty), product<=$(vRank)"}, year = 2016 , month = 1 >} qty) )
Thanks!
Many thanks! It's Working.