Creating Moving Average in Pivot Tables

[StroppyJock]

Hi

Is there any way to create an average on each row of data in a pivot table when you have one column giving you a monthly total and are using a calculated field giving the ongoing running total for the year to date. Don't seem to be able to use the running total as a field in another calcluation.

Also any ideas for moving averages in Pivots as well.

Thanks.

StroppyJock