I want to perform customer segmentation analysis based on two tables: a list of Customers and a list of Transactions. I want to add a field to my Customer table that shows total revenue for each Customer based on sales associated with that Customer in the Transactions table. A simplified data set is attached.
How can I create this additional field in my Customer table? I assume I have to use a calculated field or Custom SQL, but I am new to combining multiple data sets and appreciate your insight.
Thanks in advance!