Pivot Table - Calculated Field - Count and Sum

**rtabaldi** · 05-13-2014, 07:26 PM

Hey guys,

I have a pivot table with three columns. The first column is the name of a place. The second column is the count of events at the place and the third column is the sum of views for that event. I want to create a calculated field that divides the sum of views by the count of events, but for the life of me cannot figure it out.

In the calculated field I've tried:

=(page views/events)
=(sum of page views/count of events) - these are the column names
=((sum(page views))/(count(events)))

I know none of these are correct because I ran the calculation outside of the pivot table and have the correct value. I just want to be able to filter by this new value.

I can provide an example if necessary.

Thanks,
Ryan

**tuph** · 05-13-2014, 09:39 PM

It would be easier to work out a solution if you could attach a sample of your workbook. Remember to remove/replace any sensitive data before uploading.

**romperstomper** · 05-14-2014, 02:25 AM

Calculated fields always use SUM unfortunately. If you had 2010 I'd suggest PowerPivot but otherwise you'll need to do some calculations within the source data, or adjacent to the pivot table.

**rtabaldi** · 05-14-2014, 01:10 PM

Thank you for replying, tuph and romperstomer. Seems like it won't work as a calculated field given romperstomper's insight. I do have 2010, though, so I'll check out PowerPivot.

Thanks again!