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

[chriys1337]

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?

[ahaahaaha]

Hi,

Try

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

[sunny_talwar]

It looks right to me... have you checked what =max([Closed: kick-OUT volumes]) gives you in a text box object?

[neelamsaroha157]

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

(Double Quotes)