Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have this expression in a bar graph
SUM({<[State] = {'1', '2'}, FLAGESTATE = {'1'}>}FLAGESTATE)
I'd like to see this from the start of the 2014 to the selected month
for example if i select april 2015 i have to see january 2014, february 2014, etc.
What should i do ?
Thank you
Greetings
if you have y (year) and m (month)
= sum({$<STATE={1,2},FLAGESTATE={1},y={"$(=max(y)-1)"}>
+ <STATE={1,2},FLAGESTATE={1},y={"$(=max(y))"},m={"<=$(=(max(m)))"}>} FLAGESTATE)