Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show the last sold quantity (for max(Date) per product) in a pivot table. It works for one single product, but not for all products. Anyone has an idea?
Is this?
Try
=FirstSortedValue(Qty, -Date)
Is this?
Many thanks, I have forgotten that firstsortedvalue can have a - argument.