Pivot Table Calculated Field Sum

Good morning,
I have a calculated field in a pivot table that multiplies another calculated data field by a row field: ='6m_exc_qty'*AVERAGE(_Average_Factory_Cost)

The issue I am encountering is the subtotal of the calculated field is multiplying the sum of '6m_exc_qty' by the sum of AVERAGE(_Average_Factory_Cost). I want the subtotal of this field to just be the sum of all of the calculations. Example below the subtotal should be -15,508, not -35,088.

_Average_Factory_Cost (row field)
1.3
1.3
1.3

Sum of 6m_exc_qty (calculated data field)
-17,289
5,440
-80
-8,997 (subtotal, also not correct for similar reason )

Sum of 6m_exc_$
-22,476
7,072
-104
-35,088 (subtotal)


How do I overcome this issue?

Thanks so much and I apologize if I did not post the information in my pivot table properly.

Thank you,
N

Bump no response

If there is any additional information I can provide, please let me know.

Thank you,
N