Average of the previous 3 months data

Hello,

I have a question, 

If i want to pull the average of the previous 3 months, how can i do it? 

 

Thanks

Tagged:

Answers

  • @Luis98 

     

    Try using MOVINGSM function

     

    Formula may look like

    MOVINGSUM(Line item,-2,0,AVERAGE) 

     

    Misbah