Create a Calculated Field in a PivotTable

  • By Doug H
  • 1 November, 2017
  • Comments Off on 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.


Categories: Excel 2007 and up

Comments are closed.

Read previous post:
Use Slicers to Filter PivotTables

Have you given people you Excel file with the neat and dandy Pivot Table all ready for analysis and they...