Set analysis, disregard selection

[#1]

Hi there,

I have a date selection in my UI.  - it'a REF_DATE in my qv table

There is also a chart where I do sum(amount) in my expression.

I need another expression, which has logic

sum(if REF_DATE <= selected REF_DATE, amount, 0)

so, when I select 1 July 2014 i need to get accumulated amount until selected day.

I tried something like this, but it doesn't work. Somehow I need to eliminate current selection

=Sum({<REF_DATE={"<=$(= max(REF_DATE))"}>} amount) 

Can you please help me

Thanks

[#2 · Accepted solution]

Can you try like this

=Sum({1<REF_DATE={"<=$(= max(REF_DATE))"}>} amount)