Hi There,
I'm new here and have searched if this has already been discussed, but with no luck, so apologies in advance if this has already been resolved/explained on another thread.
I have a data sheet with sales per customer ID over a year. On a pivot table I can easily calculate the average spend of a customer, but if I want to calculate the monthly average spend of the average spend of customers I dont seem to get the correct "Total" as the
"Total" of that pivot table is the average of all transactions within that month (not taking into consideration the average of every customer).
How can I have the average of customer spend average per month?
Hopefully that makes sense
Thanks in advance.
I'm new here and have searched if this has already been discussed, but with no luck, so apologies in advance if this has already been resolved/explained on another thread.
I have a data sheet with sales per customer ID over a year. On a pivot table I can easily calculate the average spend of a customer, but if I want to calculate the monthly average spend of the average spend of customers I dont seem to get the correct "Total" as the
"Total" of that pivot table is the average of all transactions within that month (not taking into consideration the average of every customer).
How can I have the average of customer spend average per month?
Hopefully that makes sense
Thanks in advance.