Forum Discussion
Solved
Pivot Table Calculated Field
Hi, I want to add Average Profit in my pivot table for that I m using a calculated field where I m writing formula =AVERAGE('Box Office Revenue ($)')-AVERAGE('Budget ($)') but the formula somehow does not work any suggestions.
karan1796 You need to calculate the profit in your data set if you want to average it in a regular pivot table, or load the data to the data model (power pivot) and create a few measures there.
When you use a calculated field like you did, Excel sums revenue and deducts the sum of costs. Writing the formula with "AVERAGE" doesn't work.
Demonstrated in the attached file.
karan1796 You need to calculate the profit in your data set if you want to average it in a regular pivot table, or load the data to the data model (power pivot) and create a few measures there.
When you use a calculated field like you did, Excel sums revenue and deducts the sum of costs. Writing the formula with "AVERAGE" doesn't work.
Demonstrated in the attached file.
Riny_van_Eekelen Thank you sir..
