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 in the Report Design side panel.
  • Drag and drop the field to Rows.
  • 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 card, 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 in the Report Design side panel.
  • Drag and drop the field to Columns.
  • 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 card, you can also edit the Label or delete the Dimension entirely.