Please see the attachment
I have a pivot table that counts the number of instances of each actor for each location and subtotals by location. I would also like to average the count of instances of each actor for each location. Summarizing by average does not work.
I think I may need a Power Pivot measure or calculated field.
Please help!
Bookmarks