Pivot Table Calculation Field Incorrect

Hi All,

Does anyone have any ideas for my problem below:

I am using a pivot table. I have inserted a calculated field as follows:

= 'Deal %' * (Centre + End)

This works fine until it gets to the subtotal (which is needed).

Deal % is set as an Average and in the Sub Total part it answers 80% (Centre and End are both Sum Fields). However the calculated field at the sub total section it uses the sum of the averages in the Deal % column and not the Average (as displayed in the Sub Total section)?

So I tried the following:

= Average('Deal %') * (Centre + End)

This doesn't change anything. Does anyone have any ideas for how to fix this?

Many thanks in advance.

Upload your workbook. It is easier to answer by seeing your structure, field names and the data