I need the oldest PO Due Date for the same product in Viz.
Report is filtered for PO stage at 1~ 3 (Ordered, Printed, Acknowledged), below image is the result I got when using expressions:
"Desc Duedt" - LOOKUPVALUE(0, [POEL.poel_shipprod], 1, SELECT [POEL.poel_shipprod], [POEL.poel_duedt] FROM [All] ORDER BY [POEL.poel_duedt] DESC)
"Asc Duedt" - LOOKUPVALUE(0, [POEL.poel_shipprod], 1, SELECT [POEL.poel_shipprod], [POEL.poel_duedt] FROM [All] ORDER BY [POEL.poel_duedt] ASC)
None of them give me the result I want - "04/26/2022" in this case.

If I add the PO stage into the expression, like below, I get blank result
LOOKUPVALUE(0, [POEL.poel_shipprod], 1, SELECT [POEL.poel_shipprod], [POEL.poel_duedt] FROM [All] WHERE [POEH.poeh_stagecd] <=3 ORDER BY [POEL.poel_duedt] DESC)
Is this LOOKUPVALUE the right approach?