In Pivot table Why is the percentage calculated field is summed in the subtotal?

[Ali_B]

I was expecting it to be calculated similarly to the rest of the lines. Theoretical Staff Time (Total)/Actual Staff Time (Total)

here are the expressions involved:

Staff Efficiency (%):
{Theoritical Staff Time}/{Actual Staff Time}

Actual Staff Time:
sum({ACTUAL_RSRC_USAGE},[{BATCH_ID},{Product Code}])

Theoretical Staff Time:
 (({Planned Usage}*1000)/{Planned Resource Qty (Routing UOM)})*({FG (Routing UOM)})/1000

Planned Usage:
sum({PLAN_RSRC_USAGE},[{BATCH_ID},{Product Code}])

Planned Resource Qty (Routing UOM):
sum({PLAN_RSRC_QTY_ROUTING_UOM},[{BATCH_ID},{Product Code}])

FG(Routing UOM):
sum({ACTUAL_QTY_IN_ROUTING_UOM},[{BATCH_ID},{Product Code}]) 

[Ali_B]

OK, I got the issue,

from the Field Wells, I have changed the aggregation type to Average.

[heraclitus]

Changing the aggregation to Average averages the individual percentages. It does not equate to sum(Theoretical)/sum(Actual), which is what I would expect that most people want in their subtotal display.