CHURN REPORT

[#1]

Dear All,

I have a scenario in which i have to show top N Customers  in a Straight table where

if

income for Previous Financial Year Last month  > ( income  current years income /no of months of current year till today),

then

show Churn/Loss Amount= Previous Financial Year Last month -  ( income  current years income /no of months of current year)

The above thing is done.

Now i want to get the remaining customers churn amount which are not in TOP N .

Also i want to get the remaining customers amount who have not faced loss.

Please suggest me some solution.

[gaurav2017]

Hi,

can you attach a sample excel sheet to make a scenario or a sample qvw. please use sample data like

Employee          Income    

abc                    500$

xyz                    1000$

Regards,

[#3]

Hi,

Please find the attached sample data and  the report structure.