Create a Calculated Item in a PivotTable

  • By Doug H
  • 15 November, 2017
  • Comments Off on Create a Calculated Item in a PivotTable

Creating a Calculated Item in a PivotTable is one of those things you’d might not think of doing, but it has some uses.  For example, say you have some data with geographic categories like: Asia, Europe, North America and South America.  You create your PivotTable and it should summarized sales for the four geographies.  Now your boss says “I also want to see North and South America together”. Before you go and change your source data; just use the Calculated Item feature to “group” North and South America into an “Americas” category item. And it not that hard to do.  See the video to check out this near feature.


Categories: Excel 2007 and up

Comments are closed.

Read previous post:
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...