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)
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.
We are working on new matrix features to control sorting.