Powerpivot percentage calculation not showing expected results

[cooolboy]

The below link explains my pivot layout.
My Pivot table in Google Drive
I am trying to calculate percentage escalation on sales which is (Escalation/Total Sell). For this, I have created calculated column in powerpivot and use in pivot table with average aggregation. The results from Pivot are not in line with actual calculated averages.
Where as the Contingency and Margin percentages are seems to be correct due to the fact that they have same percentage for all records. Could someone point out what I am doing wrong here and how could I fix this issue?
I am sure this is bread and butter for experts but not for me as I am just starting to learn powerpivot.
Cheers

 

[scottsen]

My problem here is... I guess I don't know why the results that are displayed are "incorrect" in your view. It's certainly not doing anything crazy

If I go filter your data table down to Feature=Staff Costs (eg: Range[dbfea]=1), and then take the average of your escl% calc column, I get 8.13%... which is exactly what shows in your pivot table. So... is your calculated column incorrect?

 

[HillDragon]

My problem here is... I guess I don't know why the results that are displayed are "incorrect" in your view. It's certainly not doing anything crazy

I think the problem he was having is that he was expecting his calculated column formula to show through in the pivot table instead of getting an average of column itself.

 

[scottsen]

Aaah. An insanely typical calc column vs measures / calculated field problem?

Cooolboy, change your formulas to measures, then dance

 

[cooolboy]

Gents,

Thanks. Changing it to measures worked as expected.