Qlik Sense value require ignore date in table

[Jojo_mct]

Hi,

I have a table with 4 columns. Product, Item, Date and cost value (please see attached)

Cost value expect to populate the earliest date value group by Product & Item

My current formula as below, it only populate the cost value if date equal to earliest date (29 April)

Sum({$< [Date.autoCalendar.Date]={"$(= min([Date.autoCalendar.Date]))"}>} Value)

Appreciate if anyone could assist.

Thanks

[tresesco]

Try like:

FirstSortedValue( Aggr(Sum( Value), Product, Item, [Date.autoCalendar.Date]) , [Date.autoCalendar.Date] )

[Jojo_mct]

It doesn't work. Because the date has different date, when it is not matching min date, it will not show in the value column. 

Any other thoughts. 

Thanks in advance