Adding Fields as Dimensions (Rows & Columns)

The following section describes how to add a field as a Row and a field as a Column for the creation of a Pivot Table. These are the Dimensions of your Pivot Table and they make it more readable and detailed.

There are several options as to what to display for a Dimension, which can be added to add more detail to your Pivot table:

  • Totals
  • Missing Values
  • Percentages

You can add a vertical Dimension or a horizontal Dimension or both.

How to add a field as Row
  • After selecting the Source of Data for the Pivot Table and adding a Measure to it, select the field you want to add as a horizontal Dimension to the Pivot Table from the list of  fields.
  • Drag and drop the field to the Rows panel.
  • The horizontal Dimension has been added and you can view it on the Pivot Table.
  • To select more options as to what to display, click on the Dimension you added to reveal the Display Options and select the Options you want by ticking the boxes next to their names.
  • View the new Display Options on the Pivot Table.

In the Rows Panel, you can also edit the Label or Delete the Dimension entirely.

How to add a field as Column
  • Select the field you want to add as a vertical Dimension to the Pivot Table from the list of fields.
  • Drag and drop the field to the Columns panel.
  • The vertical Dimension has been added and you can view it on the Pivot Table.
  • To select more options as to what to display, click on the Dimension you added to reveal the Display Options and select the Options you want by ticking the boxes next to their names.
  • View the new Display Options on the Pivot Table.

In the Columns panel, you can also edit the Label or Delete the Dimension entirely.