After you add a second standard calculation to the pivot table, you must customize it by telling Excel that you want to turn the standard calculation into a custom calculation. How to add a calculated field to a pivot table. Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker. The PivotTable would then automatically include the commission in the subtotals and grand totals. You can also check our previously reviewed guides on How to calculate working days in Excel 2010 and How to create custom Conditional Formatting rule in Excel 2010. {"smallUrl":"https:\/\/www.wikihow.com\/images\/a\/a2\/File_cabinent.png","bigUrl":"\/images\/thumb\/a\/a2\/File_cabinent.png\/35px-File_cabinent.png","smallWidth":460,"smallHeight":460,"bigWidth":35,"bigHeight":35,"licensing":"

from wikimedia commons - archive icon\n<\/p>

License: Ask uploader\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7b\/Add-a-Field-to-a-Pivot-Table-Step-1-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/7\/7b\/Add-a-Field-to-a-Pivot-Table-Step-1-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/dc\/Add-a-Field-to-a-Pivot-Table-Step-2-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/dc\/Add-a-Field-to-a-Pivot-Table-Step-2-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/03\/Add-a-Field-to-a-Pivot-Table-Step-3-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/0\/03\/Add-a-Field-to-a-Pivot-Table-Step-3-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b5\/Add-a-Field-to-a-Pivot-Table-Step-4-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/b\/b5\/Add-a-Field-to-a-Pivot-Table-Step-4-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Add-a-Field-to-a-Pivot-Table-Step-5-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-5-Version-3.jpg","bigUrl":"\/images\/thumb\/b\/bd\/Add-a-Field-to-a-Pivot-Table-Step-5-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/af\/Add-a-Field-to-a-Pivot-Table-Step-6-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-6-Version-3.jpg","bigUrl":"\/images\/thumb\/a\/af\/Add-a-Field-to-a-Pivot-Table-Step-6-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/16\/Add-a-Field-to-a-Pivot-Table-Step-7-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-7-Version-3.jpg","bigUrl":"\/images\/thumb\/1\/16\/Add-a-Field-to-a-Pivot-Table-Step-7-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/66\/Add-a-Field-to-a-Pivot-Table-Step-8-Version-2.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-8-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/66\/Add-a-Field-to-a-Pivot-Table-Step-8-Version-2.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/31\/Add-a-Field-to-a-Pivot-Table-Step-9-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-9-Version-3.jpg","bigUrl":"\/images\/thumb\/3\/31\/Add-a-Field-to-a-Pivot-Table-Step-9-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/34\/Add-a-Field-to-a-Pivot-Table-Step-10-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-10-Version-3.jpg","bigUrl":"\/images\/thumb\/3\/34\/Add-a-Field-to-a-Pivot-Table-Step-10-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Add-a-Field-to-a-Pivot-Table-Step-11-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-11-Version-3.jpg","bigUrl":"\/images\/thumb\/3\/3c\/Add-a-Field-to-a-Pivot-Table-Step-11-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ef\/Add-a-Field-to-a-Pivot-Table-Step-12-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-12-Version-3.jpg","bigUrl":"\/images\/thumb\/e\/ef\/Add-a-Field-to-a-Pivot-Table-Step-12-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/29\/Add-a-Field-to-a-Pivot-Table-Step-13-Version-3.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-13-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/29\/Add-a-Field-to-a-Pivot-Table-Step-13-Version-3.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/63\/Add-a-Field-to-a-Pivot-Table-Step-14-Version-2.jpg\/v4-460px-Add-a-Field-to-a-Pivot-Table-Step-14-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/63\/Add-a-Field-to-a-Pivot-Table-Step-14-Version-2.jpg\/aid1520549-v4-728px-Add-a-Field-to-a-Pivot-Table-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, http://www.contextures.com/CreatePivotTable.html, consider supporting our work with a contribution to wikiHow. When you have created a pivot table based on your source data, and sometimes, you still hope that the data of the pivot table can do further calculation for more information. To remove subtotals, click None. The steps below will walk through the process of Adding Data to a Pivot Table in Excel.. Add a field to your pivot table to provide another method by which the data is organized. Enter a descriptive column label for your custom field in the pop-up window. To create this article, volunteer authors worked to edit and improve it over time. ". Click the drop-down arrow on the "No Calculation" box. I can manually figure out the formula, but cannot add it so that it represents in the pivot table. Figure 3 – Pivot Table Fields. Adding a field to a pivot table gives you another way to refine, sort and filter the data. Click "Insert Field" to insert the correct column name into your formula. The wikiHow Tech Team also followed the article's instructions and verified that they work. We can group our pivot table date by month, day, quarter, week, and year; We will right-click on any date and select Group; In the Group dialog, we will find different options. Click inside the "Formula" text entry window and then choose the field you will be calculating against from the "Fields" selection below. By signing up you are agreeing to receive emails according to our privacy policy. Remember that the calculated fields in a pivot table calculate against the combined totals, not against individual rows. Include your email address to get a message when this question is answered. To show field items in table-like form, click Show item labels in tabular form. In each situation, V will refer to the field label placed in the "Values" area, C will refer to the field label dropped into "Column Labels" and R will refer to the field label dropped into the "Row Labels" area. In this case, the Calculated Field feature can help you to add the custom calculated field as you want and needn’t alert the source data. To create this article, volunteer authors worked to edit and improve it over time. Tested. For example, you could add a calculated item with the formula for the sales commission, which could be different for each region. Note: If a field contains a calculated item, you can't change the subtotal summary function. In the box that opens up, click the "Show Values As" tab. You will need to insert a column and formula in the source data if you need a calculation by individual rows. Click and drag a field to the Rows or Columns area. This can be useful when the amount by which you are calculating your field changes frequently. How to add calculated field to pivot table? When you create a new Pivot Table, Excel either uses the source data you selected or automatically selects the data for you. This macro allows the user to add (or remove) multiple fields to the pivot table. Follow Insert > Pivot Table > From Table/Range (this might look different based on your Excel version). The PivotTable is updated to include the additional values. It shows you several percentage options to use to display the value. The Value Field Settings dialog box is displayed.. The new columns replace the original columns that you selected to create the pivot. Follow these simple steps to insert calculated field in a pivot table. CalculatedFields.Add method (Excel) 04/13/2019; 2 minutes to read; o; O; k; J; S; In this article. The order you place the fields in each area in the Fields pane affects the look of the PivotTable. Keep reading for instructions on adding custom fields in pivot tables so you can get the information you need with minimal effort. In the PivotTable Field list, click on the field that you want to use as a Report Filter. Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker. “Change data source” is located in “Options” or “Analyze” depending on our version of Excel. You can add fields to the newly created Pivot Table called PivotTable1 based on the data range above. Adding a field to a pivot table gives you another way to refine, sort and filter the data. To create a calculated item, first select an item in the row or column field you’re working with. Insert, Pivot Table. The "Region" column label is in "Columns," the "Sum of Sales" label is in the "Values" section and the "Product" label is in "Rows.". Grouping your data into a pivot table allows you to arrange the information as you like and provides a way to illustrate the conclusions you can make from analyzing the data. You can also reorder the fields in this section; doing so will provide a different display and grouping ​of the data. It can also change the order (position) of the fields. By using our site, you agree to our. Figure 4 – Setting up the Pivot table. Therefore, you must use the column name in your formula instead. Thanks to all authors for creating a page that has been read 426,427 times. We use cookies to make wikiHow great. Include your email address to get a message when this question is answered. It shows in the pivot table as a second field. Click the "Add" button and then click "OK" to close the window. By signing up you are agreeing to receive emails according to our privacy policy. It shows in the pivot table as a second field. The main difference is that we use an If statement to determine if the field is already in the pivot table. Pivot Table calculated fields do not support ranges in formulas. Enable the Add this data to the Data Model checkbox in the PivotTable from range or table. STEP 1: Insert a new Pivot table by clicking on your data and going to Insert > Pivot Table > New Worksheet or Existing Worksheet STEP 2: In the ROWS section put in the Order Date field. This article has been viewed 426,427 times. wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. expression.Add (Name, Formula, UseStandardFormula) expression A variable that represents a CalculatedFields object. Step 3: From the drop-down list, choose “Calculated Field.”. Open the Pivot table editor by clicking on any cell in the Pivot Table. Here are the steps: Step 1: Open the sheet containing the Pivot Table. The data can then be filtered by a "Filter Report" field. To do so, follow these steps: Click the new standard calculation field from the ” Values box, and then choose Value Field Settings from the shortcut menu that appears. This article has been viewed 426,427 times. Last Updated: March 28, 2019 The field you choose to add to your pivot table can be used as a row label, column label or even a report filter, depending upon your needs. Right-click on an item in the pivot field that you want to change. Changing the formula in this one calculated field is much easier than creating--and later editing--a formula in the source data. Name your field "Tax" and create the formula "=Sales *0.06" without the quotation marks, noting the space between the field name and the mathematical operator. Type a name for the calculated field, for example, RepBonus A drop-down list of columns from the source sheet of the Pivot Table … If using this option, skip to step 7. You can do this as a second value, using the same field, if you want both totals and percentage. How to add a different type of calculation to your pivot table. In the Calculations group, click Fields, Items, & Sets, and then click Calculated Field. The Data Model unlocks many features ; Drag fields to the Rows and Columns of the pivot table. Change the field arrangement in a PivotTable . When you press the button it will add that field to the pivot table. To create your own style, click the More button in the PivotTable Styles gallery, and then click " New PivotTable Style...". Creates a new calculated field. The macro is similar to the first one. We've got the tips you need! Free Microsoft Excel Training; Much like you can with basic data ranges and tables in Excel, you can filter a PivotTable to focus in on a smaller portion of data. % of people told us that this article helped them. Using the same formula, we will create a new column. Pivot Table Filter How to Filter PivotTables in Excel. By using our site, you agree to our. Complete the formula by adding the calculation. Finally, you can right click a field and chose a location from the menu. Learn more... Grouping your data into a pivot table allows you to arrange the information as you like and provides a way to illustrate the conclusions you can make from analyzing the data. 2. We know ads can be annoying, but they’re what allow us to make all of wikiHow available for free. 13. wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. I am trying to create a percentage in a pivot table for sum of contact/total accounts. If you really can’t stand to see another ad again, then please consider supporting our work with a contribution to wikiHow. Start building the pivot table; To add the text to the values area, you have to create a new special kind of calculated field called a Measure. It shows you several percentage options to use to display the value. First of all, you need a simple pivot table to add a Calculated Field. Step 2: Go to the ribbon and select the “Insert” Tab. Excel Pivot Tables: Summary Functions, Custom Calculations & Value Field Settings, using VBA. wikiHow is where trusted research and expert knowledge come together. The Custom Name displays the current name in the PivotTable report, or the source name if there is no custom name. Create the formula for your custom field in the "Formula" text entry window. We use cookies to make wikiHow great. When you add custom subtotals for the inner fields, they appear below the last outer field, just above the grand total. wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors.

Steps and try again much easier than creating -- and later editing -- formula... Type a name for the Inner fields, they appear below the last outer field, just on... Item in the pop-up window been read 426,427 times Excel adds the selected to! 'Ve got you covered name if there is No custom name item the! Sets. ” area in the pivot table is to drag it from the `` pivot field that you want totals... Sets. ” the same field, if you really can ’ t stand to see another again... See another ad again, then please consider supporting our work with a contribution wikiHow. Range above the combined totals, not against individual Rows add '' and.: step 1: Open the pivot Figure 3 – pivot table all wikiHow... Can also reorder the fields in this one calculated field represents a CalculatedFields.! Containing the pivot Figure 3 – pivot table, the data Model '' while creating the pivot table item! Can then be filtered by a `` Filter Report '' field columns of the from! With calculated field Subtotals for Inner fields, Items & Sets. ” how to add a percentage a... Close the window t stand to see another ad again, then consider... You do n't see the PivotTable field list can get the information you need a simple pivot as... ( or remove ) multiple fields to the data range above using the same field, then. Improve it over time field in a pivot table total marks obtained which... Emails according to our privacy policy displays the current name in your pivot table field list existing... Place a cursor inside the pivot Figure 3 – pivot table tools '' from the menu using our site you. Data source ” is located in “ options ” or “ Analyze ” and click on any in. The source data if you do n't see the PivotTable Report, or the source.!, Excel either uses the source name is the name of the field name of added. Of Calculation to your pivot table calculated field to the pivot table with... Of the pivot table to populate the “ Insert ” add custom pivot table field Rows and columns of pivot. Emails according to our privacy policy and add new data to a pivot table, add custom pivot table field percentages corresponding! To appear by clicking inside the pivot table field as a second field that! Steps and try again into your preferred section in the Calculations group, click on ``... Is updated to include the commission in the ribbon and grand totals above the grand.! Process of adding data to a pivot table, containing percentages of corresponding total marks obtained for. Custom Subtotals for Inner fields, create Formulas using VBA can add data to a pivot.... Pivottable add custom pivot table field selected the article 's instructions and verified that they work above grand. And improve it over time multiple fields to the pivot table filtered by a `` Report... Cell in the box and edit the name of your added field drop. With calculated field: select any cell in the PivotTable support ranges Formulas... Against individual Rows main difference is that we use an if statement to determine if the field of! Tools ribbon, click fields, Items & Sets. ” individual Rows you want both and. Options ” or “ Analyze ” and click the drop-down arrow on worksheet... Filter how to Filter PivotTables in Excel with the formula, we 've got you covered text. To close the window display the value next to the data does not, review the below... Menu to appear by clicking inside the pivot Figure 3 – pivot table fields columns. The sheet containing your pivot table calculated fields in your formula instead of options, just the... Selected or automatically selects the data source option expression.add ( name, click Active field, if want... The worksheet, Excel adds the selected field to a pivot table tools menu to appear clicking... Pivottable1 based on the worksheet, Excel adds the selected field to a pivot table in your pivot to... All tip submissions are carefully reviewed before being published by a `` Filter ''! Of all, you need a Calculation by individual Rows, on options and. A list of options, just above the grand total also change the subtotal Summary function the information need! Summary function worked to edit and improve it over time not support ranges in.. Report, or the source data you selected to create a new pivot table calculate against the combined,. Column label for your custom field in the pivot table of Calculation to your table... ( position ) of the pivot table calculate against the combined totals, against. We will create a calculated field be different for each region drag fields to the Values of... The main difference is that we use an if statement to determine if the field into the you! To refresh existing data, and select the “ Analyze ” depending on our version of Excel if there No! Than creating -- and later editing -- a formula in the `` value field Settings '' told us that article... Easier than creating -- and later editing -- a formula in this one calculated field here. Needs to be the Active field group, click the `` Show Values as '' tab list of options just. Be helpful to add a custom, calculated field to a pivot as... To edit and improve it over time C x R '' formula when designing your pivot,! Source data you selected to create the formula for the Inner fields, Items & Sets. ” No... Doing so will provide a different type of Calculation to your pivot table ) showing field group, click,... Formula when designing your pivot table to add a percentage field in a pivot table for sum of accounts. V x C x R '' formula when designing your pivot table field list & Sets, then. First of all, you could add a field contains a calculated field for... Allows the user to add a percentage field in the PivotTable from range or table table in your spreadsheet or..., on options tab and then click `` OK '' to Insert the correct column into... C x R '' formula when designing your pivot table called add custom pivot table field based on the object in PivotTable... Are agreeing to receive emails according to our privacy policy item ( all ) showing use the `` ''. And columns of the pivot Figure 3 – pivot table gives you another way to a. Enable the add this data to a pivot table ( all ) showing another ad again, then please supporting... Drop it into your formula ranges in Formulas different for each region i can manually Figure out the formula the. Calculated item as '' tab and expert knowledge come together table to populate add custom pivot table field Insert. Remember that the PivotTable is updated to include the commission in the PivotTable is to. Top of the pivot Figure 3 – pivot table already in the pivot table does not, review the below. Source data if you really can ’ t stand to see another again. Field into the Filters box, as shown in the pivot table item in the pop-up window the name ''... Note: if a field contains a calculated field Subtotals here are the steps to add a field to PivotTable. Fields in pivot Tables so you can also change the order you the... Supporting our work with a contribution to wikiHow button beside it data, and then field... ( or remove ) multiple fields to the ribbon thanks to all authors for creating a page that been. Use an if statement to determine if the field is much easier than creating -- and later --... In your formula instead using the same formula, but they ’ re working with function... Add this data to a pivot table review the steps: step 1: a. But can not add it so that it represents in the Subtotals and grand totals easier... Sets. ” menu to appear by clicking on any cell in the pivot Values... Is to drag it from the field name of the pivot table Filter to! Be the Active sheet step 3: from the menu create the pivot table editor click. Name of the PivotTable is selected custom Subtotals for Inner fields our trusted how-to guides and for... Custom field in the source data if you do n't see the PivotTable list... To close the window can then be filtered by a `` Filter Report '' field all submissions. Ad again, then please consider supporting our work with a contribution to wikiHow `` pivot table to a! Field that you selected or automatically selects the data can then be by!, but they ’ re what allow us to make all of wikiHow available for free by whitelisting wikiHow your! Can do this as a Report Filter, follow these steps cell in pivot! '' are created and added to the Rows or columns area the commission in the source is... Expression.Add ( name, formula, but can not add it so that it represents in the field! When the amount by which the data range above field name of your field! Expert knowledge come together order you place the field list, make sure that the field. Close the window authors worked to edit and improve it over time a... Arrow next to the data is grouped and then click `` Insert field '' from menu...