Nested set analysis - dynamic selection

[ashleywooldridg]

I have a need to get the QTY un-received for the earliest order with a un-received QTY greater than 0.

In another column on the straight table I currently get the next Order Date for this by using:

     =Min({$<[PO Unreceived QTY]={'>0'}>}[PO ETA])

I have tried to use the below to get the [PO Unreceived QTY] for the same order, but this only works when i make the selection for particular items, if not making a selection the returned value is based off all items. I have tried to include and exclude certain Tables and Fields, but this does not seem to work.

     =Sum({$<[PO ETA]={'$(=Min({$<[PO Unreceived QTY]={'>0'}>} [PO ETA]))'}>}[PO Unreceived QTY])

Is there a way to have the Min date value return the line value rather than the value based on the entire data set?

[sunny_talwar · Accepted solution]

May be try this

FirstSortedValue({$<[PO Unreceived QTY] = {'>0'}>} [PO Unreceived QTY], [PO ETA])

[ashleywooldridg]

Thank you Sunny, this works for what i require.