4 Replies Latest reply: May 22, 2018 5:11 AM by Youssef Belloum RSS

    Average calculation

    Markus Blaut

      Hi friends,

       

      I would like to calculate the average of the last 12 month (starting with 01.10.2017) and show them in a bar chart.

       

      Can anyone help me with a formula to make it work like in my screenshot.

       

      So the average from 01.10.2016 - 01.10.2017 would be 58,92 (red)

      the average from 01.11.2016 - 01.11.2017 would be 60,54 (blue)

      the average from 01.12.2016 - 01.12.2017 would be 54,39 (yellow)

      and so on...

       

       

       

       

       

      Thank you for any help!

       

      markus