Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Try
sum({<Validity={'MT'}, [Closed: kick-OUT volumes]={"<=$(=max([Closed: kick-OUT volumes]))"}>}Sales) marked in red
It looks right to me... have you checked what =max([Closed: kick-OUT volumes]) gives you in a text box object?
Sum({$<Validity={'MT'}, [Closed: kick-OUT volumes]={"<=$(=Max( [Closed: kick-OUT volumes]))"}>}Sales)
(Double Quotes)