6 Replies Latest reply on Oct 12, 2018 5:55 AM by Dipankar Roy

    Rolling 12 months sales

    koushik.neelakantha

      Hi everyone,

       

      I have a month field in MMM-yy format which is a string. I have created a calc field to convert string to date.

       

      Date calculated field: DATE(DATEPARSE ( "MMM-yy", [Month] ))

       

      Requirement: I need to calculate rolling 12 months sales and show it as a line chart with Filter as India.

       

      Note: Upon Date filter selection, line chart should show rolling 12 months.

       

       

      Help me out with the required fields needs to be taken in sheet.

       

      Regards,

      Koushik.