logo

Table report roles

Name
Type
Cardinality
Dimensions
Dimension
0 to many
Measures
Measure
0 to many
Row color saturation
Measure
0 or 1
Hidden field
Dimension
0 to many
Use table reports to show data in a tabular format, with dimension columns (1) on the left side of the table and measure columns (2) on the right side of the table.
You can also assign a measure that determines the Color saturation of the row (3).
A linear interpolation is applied from the lowest value (white) to the highest value (dark green).
Table report
Table report
Image without caption

Sorting, subtotals and grand totals

You can sort table reports by one or multiple fields (1), and show a subtotal for each level.
For each sorted field, you can choose whether to display a subtotal (2).
Date fields can display a subtotal at several levels, such as month, quarter and/or year.
A checkbox is also available to display a grand total at the very bottom of the table (3). This will only appear for reports that have at least 1 measure applied.
Image without caption