Average of the previous 3 months data

Luis98

Hello,

I have a question, 

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

 

Thanks

Misbah

@Luis98 

 

Try using MOVINGSM function

 

Formula may look like

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

 

Misbah