3 Replies Latest reply on Jun 27, 2018 4:37 AM by Deepak Busanagari

    How to get last month values with out using lookup.

    Deepak Busanagari

      Hi Everyone ,

       

      I am currently working on churn analysis in my current dashboard. I have got a requirement where I need to show churn% across the period in a line chart. The formula which we are using is sum(churn) of current month /sum(previous month subs) . As of now I am using lookup to get previous month eop subs but the problem with this is , we do not get any data at the first month in the visualization. Is there any way to achieve this without using lookup . Sample sheet attached.

       

      Regards,

      Deepak

       

      Jyothisree Rayagiri  , Mavis Liu    Can you help me in this regard.