Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Cake
Contributor
Contributor

Sum in cohort pivot table wrong

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))

0 Replies