HomeApplicationOffice information

How to Add a Column in a Pivot Table

Method 1 of 2:

Changing a Field to Column

  1. How to Add a Column in a Pivot Table Picture 1
    Open the Excel file with the pivot table you want to edit. Find and double-click your Excel file on your computer to open it.
    1. If you haven't made your pivot table yet, open a new Excel document and create a pivot table before continuing.
  2. How to Add a Column in a Pivot Table Picture 2
    Click any cell on the pivot table. This will select the table, and show the pivot table Analyze and Design tabs on the toolbar ribbon at the top.
  3. How to Add a Column in a Pivot Table Picture 3
    Click the Pivot Table Analyze tab at the top. You can find this tab alongside other tabs like Formulas, Insert, and View at the top of the app window. It will show your pivot table tools on the toolbar ribbon.
    1. On some versions, this tab may just be named Analyze, and on others, you can find it as Options under the "Pivot Table Tools" heading.
  4. How to Add a Column in a Pivot Table Picture 4
    Click the Field List button on the toolbar ribbon. You can find this button on the right-hand side of the pivot table Analyze tab. It will open a list of all the fields, rows, columns, and values in the selected table.
  5. How to Add a Column in a Pivot Table Picture 5
    Check the box next to any item on the FIELD NAME list. This will calculate the summary of your original data in the selected category, and add it to your pivot table as a new column.
    1. Typically, non-numeric fields are added as rows, and numeric fields are added as columns by default.
    2. You can uncheck the checkbox here anytime to remove the column.
  6. How to Add a Column in a Pivot Table Picture 6
    Drag and drop any field, row or value item to the "Columns" section. This will automatically move the selected category to the Columns list, and re-design your pivot table with the newly added column.
Method 2 of 2:

Adding a Calculated Field

  1. How to Add a Column in a Pivot Table Picture 7
    Open the Excel document you want to edit. Double-click the Excel document that contains your pivot table.
    1. If you haven't yet made the pivot table, open a new Excel document and create a pivot table before continuing.
  2. How to Add a Column in a Pivot Table Picture 8
    Select the pivot table you want to edit. Click the Pivot Table on your worksheet to select and edit it.
  3. How to Add a Column in a Pivot Table Picture 9
    Click the Pivot Table Analyze tab. This tab is in the middle of the toolbar ribbon at the top of the Excel window. It will open your pivot table tools on the toolbar ribbon.
    1. On different versions, this tab may be named Analyze, or Options under the "Pivot Table Tools" heading.
  4. How to Add a Column in a Pivot Table Picture 10
    Click the Fields, Items, & Sets button on the toolbar ribbon. This button looks like an "fx" sign on a table icon on the far-right end of the toolbar. It will open a drop-down menu.
  5. How to Add a Column in a Pivot Table Picture 11
    Click Calculated Field on the drop-down menu. It will open a new window where you can add a new, custom column to your Pivot Table.
  6. How to Add a Column in a Pivot Table Picture 12
    Enter a name for your column in the "Name" field . Click the Name field, and type in the name you want to use for your new column. This name will appear at the top of the column.
  7. How to Add a Column in a Pivot Table Picture 13
    Enter a formula for your new column in the "Formula" field. Click the Formula field below Name, and type the formula you want to use for calculating you new column's data values.
    1. Make sure you type the formula on the right side of the "=" sign.
    2. Optionally, you can also select an existing column, and add it to your formula as a value. Select the field you want to add in the Fields section here, and click Insert Field to add it to your formula.
  8. How to Add a Column in a Pivot Table Picture 14
    Click OK. Doing so will add the column to the right side of your pivot table.
5 ★ | 1 Vote
tablepivotclickcolumn

You should read it

May be interested

  • Table operations in WordTable operations in Word
    introduce table operations in word. table operations in word 2013 include: 1. draw cells in a table. - creating a table can not ignore merge cell operation, for example, if you want the column of the school day to have 2 values ​​of even and odd dates, make 2 columns into one.
  • Table operations in ExcelTable operations in Excel
    instructions on table operations in excel. when working with tables you should pay attention to the following: 1. edit the width of rows and columns. there are many ways to edit the widths of rows and columns. method 1: with the column moving into the vertical bar of the column - when the child
  • Manipulating tables editing in ExcelManipulating tables editing in Excel
    instructions to manipulate tables in excel. 1. insert rows and columns in the table: - for example, want to insert 1 column after salary column 1 day: step 1: select the column number of days - go to home - cells tab - insert - insert sheet column.
  • How to adjust the size of Word table cells equallyHow to adjust the size of Word table cells equally
    when entering content, the column length and width in the table will automatically change, leading to an uneven table layout. however, we can manually resize the columns in the word table.
  • How to repeat the title bar in the Word list tableHow to repeat the title bar in the Word list table
    when adding titles in columns in the list table on word, viewers can easily follow the content. the repeat header rows feature in word will help you do that.
  • How to equalize line, column, and cell sizes in ExcelHow to equalize line, column, and cell sizes in Excel
    instead of having to adjust the width and height of columns and manual lines in excel, you can use the available resizing tool.
  • 2 ways to repeat title bars in Word for tables2 ways to repeat title bars in Word for tables
    repeating titles in word is essential when you have a data table that is many pages long. repeating the table title on the next page will help readers easily understand the content in each column. there are 2 ways to repeat the title bar in a word table: using repeat header rows and customizing in table properties.
  • Instructions for separating column content in ExcelInstructions for separating column content in Excel
    to separate content in an excel field into different columns, we can use two different ways.
  • TEMPORARY TABLE temporary table in SQLTEMPORARY TABLE temporary table in SQL
    temporary table, also known as temporary table, is a special form of table that is temporarily stored and handles intermediate results on sql
  • How to draw a table - Add, edit, and delete columns in a table in Word 2016How to draw a table - Add, edit, and delete columns in a table in Word 2016
    the following article introduces you in detail how to draw a table - add, edit, delete column rows in word 2016 table.

Office information