pivot table subtotal

[JesusTello]

Good afternoon,

Attached is an example of what I'm looking for, I want the subtotals as an average no as sum.

One pivot table has the a formula to calculate the average for the subtotals which is ok, but the result is incorrect in some rows...

The second pivot table has the subtotals wrong and the rest of the rows ok.

Thank you!!

[JesusTello]

So, Can someone at least tell if it is not possible?

Thank you all.