I have pivot table .
made some calculations out of table, but related to table data.
how to make it as part of the table.
check sample file
View best response
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