max date

[p_noindl]

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?

[swuehl]

Try

=FirstSortedValue(Qty, -Date)

[ecolomer · Accepted solution]

Is this?

[p_noindl]

Many thanks, I have forgotten that firstsortedvalue can have a - argument.