The manner and function in which fields and measures are grouped and used is dependent on the type of Chart selected.

Tables

  • Columns: Can be either a field or a measure. In order to create a Table, you must drag at least one field or measure in the columns box.
  • Groups: Only a field may be added to the groups box. If you have a measure (numerical data) that you wish to use to group content within a Table, you must first right-click the measure and select select to use it as a field.
     

Charts

  • Columns: Can be either a field or a measure, but the Chart will not render without the inclusion of at least one measure (as either a column or a row). If a combination of fields and measures are placed in the Chart as columns, you must also select the depth to which to display columns through a slider in the Filters panel.
  • Rows: Can be either a field or a measure, but the Chart will not render without the inclusion of at least one measure (as either a column or a row). If a combination of fields and measures are places in the Chart as rows, you must also select the depth to which to display rows through a slider in the Filters panel.
     

Crosstabs

  • Columns: Can be either a field or a measure, depending on the manner in which you wish to group data in your Crosstab.
  • Rows: Can be either a field or a measure, depending on the manner in which you wish to group data in your Crosstab.