I'm not able to solve the third calculation. E.g. In the attached workbook we have a decrease of customers by -11 between January 2023 & February 2023.
However there are 5 new customers and 18 churned customers. How do I show the number of New & Churned customers separately per month?
4 respuestas
@Jim Dehner
In January 2023 there are 18 Customers above 100 in Profit (Big Customers)
In February 2023 there are 7 Customers above 100 in Profit (Big Customers.
The Net Increase/Decrease is -11 MoM
However, -11 is the aggregated result where 18 Churned and 5 are new.
I want to have 2 additional calculations in February 2023 showing:
Gross Increase 5
Gross Decrease -18
See image for the churned customers
