Can you get average of two sum total columns in pivot table?

[batjl9]

Hi

I have a pivot table that has two lots of values shown, one is sum of races ran and one is sum of runners ran in those races. Is it possible to add a column within the pivot table that divides the races by runners so I can get an average, or will it have to be outside the pivot table?

Thanks in advance
Gemma

[ajryan88]

Hi,

You are better off doing that out of the pivot table (even perhaps using the original data to do the calculation rather than using the pivot table to obtain that information).

If you need some help, please let me know and upload your workbook.

Thanks

[batjl9]

Thanks for reply, I will do as you suggested.

[ajryan88]

No worries.

Please don't forget to mark this thread as solved (Thread Tools --> Mark As Solved), and please click on the * next to my post to say thanks