Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
in my model i have sales (invoice lines) by date,branch and item_id
i want to retrive last sell date / max sell date for every item by branch. i will need only the positive invoice lines.
any ideas ?
advanced thanks
Hi,
maybe FirstSortedValue() can help you here
create the table you need and use the function above