Adding Fields as Dimensions (Rows & Columns)

ActivityInfo 4.0

The following section describes how to add a Form Field as a Row and as a Column for the creation of a Pivot Table.

You can make the Pivot table more readable and detailed by adding a Form Field as a Dimension. Form Fields can be added as a Row and as a Column.

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 Form Field as Row
  • After selecting the Source of Data for the Pivot Table and adding a Measure to it, select the Form Field you want to add as a horizontal Dimension to the Pivot Table from the list of Form Fields.
  • Drag and drop the Form 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 Form Field as Column
  • Select the Form Field you want to add as a vertical Dimension to the Pivot Table from the list of Form Fields.
  • Drag and drop the Form 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.