Cohort for two Formulas

[#1]

Hi All,

I need to do a Cohort Analysis likewise the one which was done by sunindia‌ attached at the bottom. This time I need to show the New Revenue and Churn. I need to show the Cust Internal ID which added new revenue and the IDs which churned. In order for one to find the new revenue and churn in the Excel sheet attached just remove the - hyphen from the filters of the columns and one will view the data.

Please provide insights.

Thanks,

[#2]

Thanks Sunny, how can I make the above chart from the table? This will determine the validity of the Quantity fields.

Please provide assistance!!!

[sunny_talwar]

Not sure I understand. The chart was already created, right. Why are we recreating it?

[#4]

The above chart was part of one set of data. The chart I need to make now is part of another set of data. The above chart was part of the STK Excel sheet while this new chart (with your kind assistance) will be of Book1 Excel sheet.

[#5]

Hi Sunny,

Do you've any insights on this matter?

[sunny_talwar]

I am looking, I don't have anything as of now. I need Kush141087‌ here .

[#7]

Thanks for the reply!!!!!!

[sunny_talwar]

How is this looking?

[#9]

Hi Sunny,

I'm attaching the Book1 sheet within I've done pivot tables for both Churn and New Revenue. The benefit of the pivot table....I was able to get the unique IDs for the New Revenue and Churn. Please provide any assistance!!!! The quantity doesn't seem to match up.

[sunny_talwar]

You earlier provided me with this:

The number for dollar are matching with this, are we only talking about Quantity still or we have incorrect numbers for Dollar as well?

[#11]

The dollar figures look good, that's not the concern; the concern is the quantity. I'm attaching sheet where I've highlighted how the quantity should look like or be close to.

New Revenue

Churn