Hi All,

I am relatively new to tableau and am having difficulty in calculating new buyers and churned buyers count.

When a buyer makes revenue in Jan and doesn't make any revenue in Feb, he is considered churned for Feb

Likewise, When a buyer's revenue is zero/null in Jan and greater than zero(some revenue) in Feb, he is considered as a new buyer for Feb.

When a buyer makes his first revenue in Jan, zero in Feb and some revenue in March, he is considered churned for Feb and new buyer for March.

I am trying to get it in a table format like below( ignore the numbers, they are incorrect)

I used lookup to count new buyers but I'm having difficulty in doing the Sum of AGG. Min date didn't work either as i some cases, paused and renewed buyers are also counted as new buyers.

I have attached the workbook and sample data. Please help!!

Thanks!