Forum Discussion

ndmalam's avatar
ndmalam
Copper Contributor
Nov 07, 2020
Solved

Calculations made outside the pivot table

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
excel
  • ExcelExciting's avatar
    ExcelExciting
    Nov 09, 2020

    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

     

     

     

ExcelExciting's avatar
ExcelExciting
MVP
Nov 09, 2020

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