logo

Matrix report roles

Name
Type
Cardinality
Columns
Dimension
0 to many
Rows
Dimension
0 to many
Cell text
Measure
0 or 1
Cell color saturation
Measure
0 or 1
Use matrix reports (also known as pivot tables or cross tabs) to show your data in a tabular format, with dimensions across both rows and columns, and data cells showing 1 or multiple measures.
  • Assign one or more dimensions to columns
  • Assign one or more dimensions to rows
  • Assign a measure to the cell text
  • Assign a measure for the cell color (optional)
  • A linear interpolation is applied from the lowest value (white) to the highest value (dark green)
Image without caption
Subtotals and grand totals can be added to reports by enabling ‘Show’ totals on the field you’d like to total.
In the above example, to see the total sales by shipping state across all years, you would enable ‘Show totals’ on the ‘YEAR Date’ field (example below). To see a total by year across all states, you would enable ‘show totals’ on the ‘Shipping State’ field.
Image without caption
We are working on new matrix features to control sorting.