Forum Discussion
Pivot Table Calculated Field
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..