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

    Rolling 12 months sales


      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.