CRM - list all Purchases done by a Customer

if a company grows mainly by selling more products to existing customers it’ll help to provide Sales Staff with an overview of all items purchased by a certain customer (so they can approach them for buying items they have not purchased before). In my usecase Customers very rarely would by the same item twice.

how can you achieve this? I expected this to be very easy to achieve but fuddeling around got proven wrong. Is there any report I need to design? if so, where can you learn to design such a report?


Please check


thanks. that seems to be the way to go