slider nd accumulation

[#1]

hi

my requirment is like bar chart displaying  10  yrs historical data.whenever client elects the particular yer like 1993.he needs to get accumulation of last 3yrs like 92,91 and 93.how to solve this requirement.

value should pass dynmically to the slider.

[Gysbert_Wassenaar · Accepted solution]

Try sum(Year={'>$(=max(Year)-2)<=$(=max(Year))'}Amount). If that's not the answer you're looking for then please post a document with data and an explanation.

[#3]

if above gysbert answer is not working

u may try in chart level like

above(sum(amount),3))

or

accumation 3 steps back