Link to home
Create AccountLog in
Avatar of chris_desborough
chris_desboroughFlag for Australia

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.
Avatar of TommySzalapski
TommySzalapski
Flag of United States of America image

Just use total instead of average then add a formula field that equals total/6?
ASKER CERTIFIED SOLUTION
Avatar of TommySzalapski
TommySzalapski
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of chris_desborough

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.