1 Reply Latest reply: Aug 20, 2014 11:06 AM by Kothandaram Mugalipoo RSS

    Set analysis, disregard selection

      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