Pivot Table, average of sums in column

I have a group of data that is listed as sums.

Ex:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Now at the bottom, I would like two things. First, a count of the rows.
More important, I want the average of the totals (in this case, 31/3 = 10.33)

When I tell it to average, it just gives me the average of each person (joe goes to 7.5, fred goes to 5.5)

In regards to the count, I saw in another thread they said to just add a column that says "1" for each row, and sum that at the bottom. I would like to do this without an additional column, but if that's the only way then that is fine.

Thanks

Hi,

I have created a sample template by going through the description provided by you (uploaded here). Please see if this suits your requirement.

Regards,
Chandra



Please click on ‘* Add Reputation’ if I was helpful in resolving the issue.

Looks good, but how did you do it?

Thanks

I have added a count field in the raw data for counting the unique names, then I added this as a field in the pivot table (SUM). The Average is a calculated field under "Fields Items & Sets" under Options Menu.

The count part I get, but still not understanding the average one. Can you walk me through step by step what you did?

Hi,

Please go through the following URL for more details on adding Calculated Fields into a Pivot Table:

http://www.addictivetips.com/microso...le-excel-2010/



Regards,
Chandra



Please click on ‘* Add Reputation’ if this was helpful