2 Replies Latest reply: May 20, 2013 7:24 AM by JATIN KOLHE RSS

    CHURN REPORT

      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.