Selecting multiple records from the same NL("Rows",...)

Hi all,

Wondering if the following is possible:

Is it possible to subfilter NL("Rows",… so that from this I can get the max/last and min/first posting date into two separate cells on the same line?

…
…


More technical explanation below:

For every Item No. I select from =NL("Rows","Item",,"+No.",$C$2,"Blocked","FALSE","Category",$C$4,"Item Stock Value",$C$3)
…I need the Last Sale Date, First Purchase Date and Last Purchase Date, as well as other information.

I am using three more NL functions to and an NF(…,"Posting Date") to get the dates from:

Last Sale Date: =NL("First","Item Ledger Entry",,"Item No.",J9,"Entry Type","Sale","-Posting Date","*")First Purchase Date: =NL("Last","Item Ledger Entry",,"Item No.",J9,"Entry Type","Purchase","-Posting Date","*")`
Last Purchase Date: =NL("First","Item Ledger Entry",,"Item No.",J9,"Entry Type","Purchase","-Posting Date","*")
As you can imagine, for ALL item records, this can be a quite laborious report.

I am wondering if I could combine the three NLs above into a single NL("Rows",… and somehow sub-filter from this with the Entry Type to pick the first and last Posting Date.

Probably, I am making things even more complicated, but if there was a single NL("Rows",… then there would be less calls to the database.


Any help appreciated.


The datalore.