How to Remove Old Row and Column Items from the Pivot Table in Excel? How to Automatically Insert Date and Timestamp in Excel? Excel Pivot Table Calculated Field Creating A Calculated Field In. 2. on the pivottable analyze tab, in the calculations group, click fields, items & sets. Before inserting a calculated item, take into account the following restrictions. To delete a calculated item, invoke the Insert Calculated Item dialog, select the required item from the Name drop-down list and click Delete. Here you wont need to go back and add it to the source data. To insert a calculated item, execute the following steps. Instead, you can utilize a Pivot Table Calculated Field to accomplish this. The new calculated item can be called writing instruments that will be equal to: Writing Instruments = Pen + Pencil + Pen Set. To learn more, see the following articles: Measures are used in data analysis; for example, sums, averages, minimum or maximum values, counts, or more advanced calculations that you create using a DAX formula. 1. click any cell inside the pivot table. Made within Istanbul. Excel Formulas To overcome this issue, you need to follow the next steps: From the Events_Record worksheet, go toPower Pivot > Manage.