Set Analysis question

[#1]

Hello everyone

I need a sum on a interval but the max value of the interval is going to be selected by the user. for example if i have year field going from 1997 to 2007 and the user selects 2005 I need the total of CA from 1997 to 2005. I tried every possible set Analysis expression I could think of.

Thanks in advance for your help

[swuehl · Accepted solution]

Have you tried something like

=sum( {<Year = {"<=$(=max(Year))"}>} CA)

[jagannalla]

Hello,

See the attached file. Hope it helps you.

[#4]

it does work! THANK you so much both of you for helping me, I got lost at a certain point, trying every possible expression i could think of. have a lovely weekend