Below is a requirement I'm trying to calculate in Qlikview.
Find the most recent Order date for Customer and Product combination. The most recent date isn't always the same.
After I have a unique Customer, Product, most recent Order Date combination I'd like to do then sum up the sales for this combination on this date.
I've tried using aggr etc but somehow I'm missing something with the syntax. Syntax would be helpful!!