3 Replies Latest reply: Apr 11, 2017 11:22 AM by neelam sehrawat RSS

    Set Analysis select a date, up to this date the information should be shown

    Christian Schmitz

      Hi all,


      I am having a table with sales figures including a calendar week field ([Closed: kick-OUT volumes], e.g. 201717).


      I would like to select just ONE week in this field and my chart should show all figures up to this week.


      I realized that it should be possible with Set Analysis, but somehow it does not work for me:


      sum({<Validity={'MT'}, [Closed: kick-OUT volumes]={'<=$(=max([Closed: kick-OUT volumes]))'}>}Sales)

      Is anything wrong with my expression?