Total Spend per Customer

[ldean]

Dear Alteryx Community,

I have added a column using the formula tool for Total spend (I multiplied the Average Spend by Annual visits).  I am tasked to add another column called Total spend per Customer. I have a column with Customer IDs which I need to total - how do I do this? I also need to total the Total Spend. Once I have these numbers I should be able to create the Total Spend per Customer column by simply dividing total spend by the number of customers.

I just need help with how to total or add the data in a column first.  Can somebody give me some advice?

Thanks again!

[christine_assaad]

Hi @ldean 

if I understand your challenge correctly, you can try to add a "Summarize" tool to get the Total of customers as well as Total Spend. Then you can use "Append Fields" to append these 2 fields to your main dataset.

Hope this helps. Cheers!