Hi, having an issue with getting to a monthly spending customer average and wonder if someone can help - sure it's come up before but not been able to find a fix. The below is an example of the calculation I'm trying to get to, with each particular store as the dimension. So from that table I'd want to show Store 1 - 339, Store 2 - 628 and so on
Using the Avg & Aggr functions gets me to an average across the whole group of stores but doesnt show with the branch as dimension, expression = avg(aggr( sum(SpendingCustomers), Month) ??