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

     

     

     

1 Reply

  • 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