Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I want to calculated the sum of 6 rolling months in a table graph dynamically based on the period selected by the user.
If the user select period 201006 (i.e PeriodCounter) I want the table to sum the amount for 201001-201006.
I'm trying to use this expression but i don't get the correct result. What am I doing wrong?
sum({$< PeriodCounter = {">$(=max(PeriodCounter)-6)"},PeriodCounter = {"<=$(=max(PeriodCounter))"},[Year Month]={"*"}>} Amount))
BR
Zandra
Thank you!
I managed to solve it another way:
= sum({$< PeriodCounter = {">$(#=max(PeriodCounter)-6) <=$(#=max(PeriodCounter))"},[Year Month]={"*"} >} Amount)