Hi,
I need the number of customers onborded per month as picture shows. I get the correct numbers for each row. However I also need to total row to sum correctly for each column. Now i get the same total for all columns which is not correct. Does any one have any idea how to do that. I'm using the following formula to get the numbers for each row:
=sum(total <YearMonthNewCust>
aggr( distinct count(distinct total < YearMonthNewCust> customer_id), YearMonthNewCust))