HomeApplicationOffice information

How to Add Columns in a Pivot Table

Change data fields to columns

How to Add Columns in a Pivot Table Picture 1

Open the Excel file with the pivot table you want to edit. Find and double-click the Excel file on your computer to open it.

If you haven't created a pivot table yet, open a new Excel document and create a Pivot Table before continuing.

How to Add Columns in a Pivot Table Picture 2

Click any cell in the pivot table to select it. The Pivot Table Analyze and Design tabs appear in the tools ribbon at the top of the screen.

How to Add Columns in a Pivot Table Picture 3

Click the Pivot Table Analyze tab at the top. This tab is located alongside other tabs (such as Formulas, Insert, and View) at the top of the application window. The Pivot Table tool appears in the tools ribbon.

On some versions, this tab is called Analyze for short or appears as an option under the "Pivot Table Tools" heading.

How to Add Columns in a Pivot Table Picture 4

Click the Field List button in the ribbon. This button is to the right of the Pivot Table Analyze tab. A list of all fields, rows, columns, and values ​​in the selected table will appear.

How to Add Columns in a Pivot Table Picture 5

Check the box next to any item in the FIELD NAME list. The sum of the original data in the category you select will be calculated and added to the pivot table as a new column.

Typically, non-numeric data fields are added as rows, while metric fields are added as columns by default.

You can uncheck the check box here at any time to delete the column.

How to Add Columns in a Pivot Table Picture 6

Drag any field, row of data, or item of value and drop it into the "Columns" section. The selected category will automatically be moved to the Columns list and the pivot table will be redesigned with the newly added column.

Add calculated fields

How to Add Columns in a Pivot Table Picture 7

Open the Excel document you want to edit. Double-click the Excel document that contains your pivot table.

If you haven't created a pivot table yet, open a new Excel document and create a Pivot Table before continuing.

How to Add Columns in a Pivot Table Picture 8

Select the pivot table you want to edit. Click Pivot Table on the spreadsheet to select and edit.

How to Add Columns in a Pivot Table Picture 9

Click the Pivot Table Analyze tab . This tab is located in the middle of the tool ribbon at the top of the Excel window. The Pivot Table tool opens on the tools ribbon.

On some versions, this tab is called Analyze for short or appears as an option under the "Pivot Table Tools" heading.

How to Add Columns in a Pivot Table Picture 10

Click the Fields, Items, & Sets button in the tools ribbon. This button has the word "fx" in the table icon at the bottom right of the toolbar. A drop-down menu will appear.

How to Add Columns in a Pivot Table Picture 11

Click Calculated Field in the drop-down menu. A window for you to add a new custom column to the Pivot Table will open.

How to Add Columns in a Pivot Table Picture 12

Enter a name for the column in the "Name" field. Click the Name data field and enter the name you want for the new column. This name will appear at the top of the column.

How to Add Columns in a Pivot Table Picture 13

Enter the formula for the new column in the "Formula" field. Click the Formula data field below the Name field and enter the formula you want to use to calculate the data value in the new column.

You need to make sure you enter the formula to the right of the "=" sign.

Or you can also select an existing column and add it to the formula as a value. Select the field you want to add to the data fields section here and click Insert Field to insert it into the formula.

How to Add Columns in a Pivot Table Picture 14

Click OK . The column will be added to the right of the pivot table.

5 ★ | 1 Vote

You should read it

May be interested

  • Add rows and columns - Delete rows and columns - Align rows and columns evenly in the Word tableAdd rows and columns - Delete rows and columns - Align rows and columns evenly in the Word table
    the following article details how to add rows and columns - delete rows and columns - align rows and columns equally in word table
  • 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.
  • ALTER TABLE statement in SQL ServerALTER TABLE statement in SQL Server
    in sql server, the alter table statement is used to add columns, edit columns, delete columns, rename columns or rename tables.
  • Use VLOOKUP to join two Excel tables togetherUse VLOOKUP to join two Excel tables together
    connecting columns of this table to another table is often complicated because the rows in this table do not always correspond to the other table. by using vlookup to join the table you will avoid these annoying sorting problems.
  • 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
  • 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.
  • Manipulation editing on a table in WordManipulation editing on a table in Word
    introduce editing operations on tables in word. the editing operations on tables in word include: 1. insert more rows and columns. - insert additional columns into the table - select the column position next to the columns you want to insert - into the layout tab - include the following options ...
  • How to convert columns into rows and rows into columns in ExcelHow to convert columns into rows and rows into columns in Excel
    you need to convert excel columns into rows or convert data in excel rows into columns, if retraining takes a lot of time, just a trick that network administrator instructs below, you can turn the rows into columns or columns into rows extremely easy.
  • Add tables to slides in PowerPointAdd tables to slides in PowerPoint
    introduce how to add tables to slides in powerpoint. 1. create a table - go to insert - table tab - select the number of rows and columns to create as shown: or you can click insert table to enter the desired number of columns and rows.
  • How to fix columns in ExcelHow to fix columns in Excel
    how to fix columns in excel. for excel spreadsheets that have a large number of columns, you want to freeze the first columns so that when you move the mouse over the column larger than the number of columns displayed in excel, these columns remain the same.

Office information