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.