Moving Average Last 30 Days

[vinicius_siquei]

Folks,

I have one chart just like the one on the image below. What I need to do is:

   - Present only the last 5 days (It must change according to the period filtered)

   - Display on the line, the Moving Average from the last 30 days.

Could anyone help me build the moving average ?

In case that displaying only the last 5 days could make things to hard, It okay to handle and have bigger periods. But I do need to have the Moving Average.

I'm attaching one sample file so we can try to do that.

Thanks in advance.

[Gysbert_Wassenaar]

A practical way to create a moving average is using an AsOf table. See this document for an explanation and examples: Calculating rolling n-period totals, averages or other aggregations

[MK_QSL]

Check Enclosed file...