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