4 Replies Latest reply: Sep 30, 2016 12:25 PM by Ganesh Bagavathi RSS

    Script calculation, Charting rolling months, average calculation

    Ganesh Bagavathi

      Hello,

       

      I have a need to create a bar chart which will display the past 12 months including the current month with some calculations.

      Rolling 12 months formula is available in plenty across the community, but my problem is calculating the average of a particular column from previous year. I have attached an excel which covers all the details, let me know if you need more information.

      Thanks.