You can dock the PivotTable Field List to either side of the Excel window and horizontally resize it. By default, the PivotTable Field List displays two sections:Ī field section at the top for adding fields to and removing fields from the PivotTableĪ layout section at the bottom for rearranging and repositioning fields To know more about Excel go through our Formulas.ĭo follow our YouTube channel for regular updates.When you create a PivotTable, Excel displays the PivotTable Field List so that you can add fields to the PivotTable, rearrange and reposition them as needed, or remove them from the PivotTable. The below image will help you to understand better. What happens if you enter the name from the dataset into the Insert Calculated Field dialog box? It will automatically hide the options from the user. If you try to delete that field by selecting and pressing Delete, then Excel will throw a warning message stating that it will affect a pivot table.Īs we already know that if you add a field using calculated field then you can edit only that field. Step 3: Once you click OK, a field will be removed from the pivot table. Step 2: Enter the field name you want to delete and click Delete and then click OK. Follow Step 1 to Step 4 of Insert calculated Field steps to open the dialog box. Step 1: To delete the field, you need to open the Insert Calculated Field dialog box. Follow the below steps to delete a calculated field in the pivot table. Now I want to delete the “Bonus” field as their bonus period is over. Using the above example, I have already modified the “Bonus” field in the pivot table to increase the bonus for each employee. You can delete a calculated field that you have inserted. Delete a Calculated Field in the Pivot Table Step 3: Once you click OK, a field will be modified into the pivot table. )” field by calculating it by 3 percent to increase the bonus. Here I have entered the field name as “Bonus” and typed the formula using the “Salary ( in Rs. Step 2: Enter the field name you want to modify and enter the modification formula you want to calculate either by typing in the Formula textbox or by selecting the field name in the Fields list box and click Modify and then click OK. Follow the above Step 1 to Step 4 to open the dialog box. Step 1: To modify the field, you need to open the Insert Calculated Field dialog box. Follow the below steps to modify a calculated field field in the pivot table. Now I want to modify the formula by increasing the bonus to 3 percent. Using the above example, I have already added the “Bonus” field in the pivot table to find the bonus for each employee. You can modify a calculated field according to your wish. Modify a Calculated Field in the Pivot Table Here you can see the “Bonus” field in the PivotTable Fields panel. In the PivotTable Fields panel, the newly inserted field will be stored in it. Step 6: Once you click OK, a field will be inserted into the pivot table. )” field by calculating it by 2 percent to offer the bonus. Step 5: Enter the field name you want and enter the formula you want to calculate either by typing in the Formula textbox or by selecting the field name in the Fields list box and click OK. Step 4: An Insert Calculated Field appears in the window. Step 3: Once you insert the field into the pivot table, click on any cell in the pivot table and go to Analyze > Fields, Items, & Sets > Calculated Field. By default, it will show you the sum or count values in the pivot table. Row or Column Labels are used to apply a filter to rows or columns that have to be shown in the pivot table. When you select the field name, the selected field name will be inserted into the pivot table. Step 2: To add a field, Tick the checkbox before the field name in the PivotTable Fields panel.
To know how to create a Pivot table please Click Here. Step 1: The first step is to create a pivot table for the data. Follow the below steps to insert a calculated field in the pivot table. If you add a field using a calculated field then you can edit only that field.Įxample: Here I have a list of salesperson details, now I want to add the field in the pivot table to offer the bonus for each employee. Insert a Calculated Field in the Pivot TableĬalculated Field option in the pivot table will help you to add, modify, or delete your field in Excel. Is the pivot table doesn’t allow you to edit the data? Not able to add, modify, or delete your field? Do you have any idea about the calculated field? Then this article will help you to know about the calculated field option in the pivot table to solve this problem.