Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm facing some problem with following script ( Please see attached sample as well). Basically, I would like to accumulate 10 years of Qty based on my dimension year. I wonder if there is any simplified and dynamic scripting so that i do not have to hardcode every year from 2019 onwards.
Greatly appreciate your help on this!
Expression:
=IF(CalendarYear='2019',
Sum({$<CalendarYear={">=2009<2019"}>} Total Qty),
IF(CalendarYear='2020',
Sum({$<CalendarYear={">=2010<2020"}>} Total Qty),
IF(CalendarYear='2021',
Sum({$<CalendarYear={">=2011<2021"}>} Total Qty),
Rangesum(Above(SUM(Qty),1,rowno())))))
Hi, have you tried?: Rangesum(Above(SUM(Qty),1,10))
Hi, have you tried?: Rangesum(Above(SUM(Qty),1,10))
Yes, it works! Thank you so much!