Creating Moving Average in Pivot Tables

StroppyJock

New Member
Joined
Apr 7, 2009
Messages
2
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
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,100,211
Messages
5,473,195
Members
406,851
Latest member
Debbren

This Week's Hot Topics

Top