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