Nov 07 2020 06:39 PM
Nov 09 2020 01:22 AMSolution
Please see the attached file with the calculation inside the source table and then add to PivotTable, there are other ways to do such calculation using PowerPivot.
I have added new column to the source data and perform the same calculations using SUMIF & when you drop the value into the PIVOT make sure it average not as sum.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more