Hi All,
I need to perform customer analysis across the quarters as below.
Ex:
Q22021-A,B,C
Q32021-B,C,D,E,F
Q42021-C,G,H
How to calculate % of carry over from out of 3(A,B,C) from Q2 only 2(B,C) customers has a transaction in Q3,so it should be 67%
How to calculate % of carry over from out of 5(B,C,D,E,F)rom Q3 only 1(C) customer has a transaction in Q4,so it should be 20%
Expected Result
Carry over % -(2/3)*100 -66%
Carry over % -(1/5)*100 -20%