Search This Blog

Monday, May 6, 2019

Create a Calculated Field in a PivotTable

Calculated Fields in PivotTables are just an extra way to create different calculations for your data without messing with the source data. Say you had sales data and wanted to get the profit margin. Instead of adding an extra column in your source data for the PivotTable, you can can create the PivotTable and then use the calculated field command to create the formula to do that. It sounds complicated but it's not really that hard to do. Check out the video to see an example.

1 comment:

  1. Hi, I'm trying to do the same thing, the difference is I'm putting condition on percentage values. I followed each and every step in the exact same manner, but I was not able to get to the desired result. I couldn't share screenshot over here, otherwise I could have shown you. Is there a way I can share you the screenshots, so you could suggest some change which will help me get to the desired result?