Amount of sales and date of last shipment

[kolov007]

Hello.

Help me please solve the following task

I have a table with sales of goods in outlets:

I need to make a report that would show the date of the last sale to the outlet and the amount of the last sale in the context of each product. For example:

Help me please.I'll be very grateful.

[sunny_talwar · Accepted solution]

Something like this when Product is selected?

[kolov007]

Thank you)