Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
if above gysbert answer is not working
u may try in chart level like
above(sum(amount),3))
or
accumation 3 steps back