Data selection based on another selection

[#1]

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

[sunny_talwar · Accepted solution]

May be try this:

Sum({<Week = {"$(=Min({<Year = {$(=Max(Year))}>}Week))"}>}Stock)

[#3]

Thank you so much - works perfectly !!!!!!!!!!!!!!!!!!!!