Hi,

I'm currently building a pivot table consisting of weekly sales figures and would like to add a calculated field to generate the average sales from the last 4 weeks.

I can do this outside of the pivot, using the average formula but ideally need it as a Pivot Table field.

Is this possible?

I searched for a solution before creating this thread btw.

Thanks in advance.