chris_desborough

asked on

# Rolling average in Pivot Table

I have extracted data for clients who have sent referrals over a 6 month period. I've created a pivot table with the sum totals for each client and want to add a 6 month average for each of these referrrer totals to the table. However, some of the clients haven't sent referrals all 6 months so when I use the avg function it doesn't average the total over 6. I created a calculation to the side of the table to work this out but of course when I filter the table these calculations won't be part of the filter.

Just use total instead of average then add a formula field that equals total/6?

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

Thanks Tommy. This worked. I didn't realise you could add formulas into pivot tables this way. Many thanks. BTW, I couldn't find the Formula option in the Insert tab but in the Options tab along the ribbon once the Pivot Table was selected.