Forum Discussion
Get total sales per customer
You probably already have an answer but I found a good solution and thought it might help others.
Use the Consolidate feature on the data tab.
Good video here https://www.youtube.com/watch?v=IGaq_biQ1B8
Ad2Mollie Perhaps a simple pivot table is enough. Customer ID and Name as Row labels, Sales amount in the Value field and perhaps the Date (grouped by year) as the Column label.
I would NOT create a pivot table with all the address information included. Couldn't it be that customer information changed over the years? Perhaps they moved or changed phone number. I presume you have assigned unique customer ID's, so a pivot table with just the ID and a name (for legibility) should suffice. Current customer information is best kept in a separate database/table.