Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Based on the data below, I am trying to achieve as a chart expression the following...
Sum of stock for the minimum week number in 2016 i.e. 40 (from week 11)
& am trying things like this...
=SUM (if(Year=2016 and Week= (Min(if(Year=2016,Week))) ,Stock))
or
=SUM ({$<Week = {$(min(total Week))} ,Year ={2016}>} Stock)
but it is not happy with any of these logics... any ideas please ?
Thanks in advance
Bob
Year | Week | Stock |
---|---|---|
2015 | 3 | 10 |
2015 | 4 | 20 |
2015 | 5 | 30 |
2016 | 11 | 40 |
2016 | 12 | 50 |
May be try this:
Sum({<Week = {"$(=Min({<Year = {$(=Max(Year))}>}Week))"}>}Stock)
May be try this:
Sum({<Week = {"$(=Min({<Year = {$(=Max(Year))}>}Week))"}>}Stock)
Thank you so much - works perfectly !!!!!!!!!!!!!!!!!!!!