Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is expression : sum ( sales)
Here is dimension : Yr = ( 2015, 2016, 2017)
How do I write expression so it returns values for ANY YEAR selected minus prior year ?
sum({<Yr= {'$(=max(Yr))'}>}sales) - sum({<Yr= {'$(=max(Yr)-1)'}>}sales)
sum({<Yr= {'$(=max(Yr))'}>}sales) - sum({<Yr= {'$(=max(Yr)-1)'}>}sales)