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,

[sunny_talwar]

Do you have a plan on how it is going to look?

[#3]

Hi Sunny, thanks for the responding. This time the good part is we've been provided a months field so no need for a cross table. Something that looks like the below table. Lets start from there if it's possible please.

[sunny_talwar]

Month field is provided? Not sure what you mean? You don't need a pivot style table this time?

[#5]

In the Qlikview file attached you'll find the details. Please like the table below but this time no change in existing column.

Thanks,

[sunny_talwar]

Where would that number go then (I mean 'Change in Existing')?

[#7]

Thanks Sunny, I want something like the below. You can neglect change in existing column because it doesn't concern us in this report.

[sunny_talwar]

It would be easier if you can fill in the values you are expecting to see in each of those cells

[#9]

Thanks Sunny for instructing me on that, it actually made me realize my mistakes.

This is the depiction of the table in Qlik.

Please provide assistance.

[sunny_talwar]

Not sure how you are calculating the two Quantity fields, but the Dollar amount seems pretty straight forward: