You can easily remove calculated fields and items from an Excel pivot table. To remove a calculated field, click a cell in the pivot table. Then click the Analyze tab’s Fields, Items & Sets command and choose Calculated Field from the submenu that appears. When Excel displays the Insert Calculated Field dialog box, select the […] In a pivot table, you can create calculated items, in addition to the pivot items from the source data.They can create problems in your pivot table layout, such as showing cities under every region, instead of just the region in which they’re located. Calculated items in Excel Services. In Excel, people can create calculated items that include Calculated Measures, Calculated Members, and Calculated Fields. Calculated items enable you to define and use custom calculations and sets of items that do not exist in the databases that are used to create PivotChart reports or PivotTable reports.