You are asked to enrich a customer dataset in your lakehouse by adding a new column that calculates the total purchase amount for each customer. Describe the steps you would take to achieve this, including any necessary data transformations and the method of adding the new column.