Hi,
For a small sample of Product & Inv data I've managed to pull through the last time a Product was sold. However, how do I adapt this to pull through the last time Product was sold to certain customer.
So that my 1st col is "Customer" then "SKU" then "Description" finally "Date"...Date being last instance of sale to said customer.
I think I need to adapt this step somehow (attach).
In excel I think I could do this with Index match. So I'm looking up 23 variables and then only latest instance.
Currently the query outputs via prod per below. I've just deleted the step deleting MaxDate so can check it was working.
Many thanks
Gareth
For a small sample of Product & Inv data I've managed to pull through the last time a Product was sold. However, how do I adapt this to pull through the last time Product was sold to certain customer.
So that my 1st col is "Customer" then "SKU" then "Description" finally "Date"...Date being last instance of sale to said customer.
I think I need to adapt this step somehow (attach).
In excel I think I could do this with Index match. So I'm looking up 23 variables and then only latest instance.
Currently the query outputs via prod per below. I've just deleted the step deleting MaxDate so can check it was working.
Many thanks
Gareth