Calculations made outside the pivot table

[ndmalam]

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

[#2 · Accepted solution]

Hi @ndmalam 

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