Next arrivals

[spividori]

Hi.

I have to determine the next arrivals for each product, with date and quantity.
This is for the Stock = 000002, that value is in the variable 'sSitio'.
I can not do it by script, I need to solve it in the pivot table.
For example: 001.001.05.0007 product should show: NextArrivals = 27/07/2013, Quantity = 105.

File Attachment..

[spividori]

Any suggestions?. Help please!. Thank you.

Regards.

[Clever_Anjos · Accepted solution]

=min({<Stock={"$(sSitio)"}>} Ingreso)

firstsortedvalue({<Stock={"$(sSitio)"}>}Cantidad,Ingreso)

[spividori]

HI Clever.

Thank you. Works perfect.

Regards.