Docs · Visuals
Tiers guide
The matrix header you draw on a whiteboard.
Fields
| Field well | What to put in it |
|---|---|
| Rows | One field, such as city. |
| Column groups | The header levels, top first. Two levels are free; a third and fourth are Pro. |
| Value | The measure in every cell, such as orders. |
Set it up
- Add Tiers to the report page (see Install the visuals) and drag in the fields above.
- In Format › Labels, rename the label above the columns (a single dash hides it) and the words “Subtotal” and “Total”.
- In Layout, switch off group subtotals, the total column or the total row, and choose roomy, normal or compact rows.
In the report
- Hover a cell for its row, its column groups and the value.
- Click a row name or a cell to filter the rest of the report; Ctrl+click to pick several.
- The header stays at the top and the row names at the left when the table scrolls.
- The measure’s number format, with display units if you want them.
- Light or dark background, high-contrast mode, and your own subtotal and total shading.
- Tab into the table and move with the arrow keys. The fold arrows are buttons. Screen readers get a real table with headers.
- The format pane and messages are in English and Norwegian.
Pro features
- More levels: a third and fourth column level, each with its own subtotals
- Percentages: each cell as a share of its row total or column total
- Shading by value: cells darken with their value, like a heatmap
Pro features need a licence key for Tiers or Everything, or a 14-day trial key. Without a valid key, Tiers shows two levels, plain values and no shading, with a short notice above the chart and a “Try Pro free” button. Everything else keeps working. See Add your licence key.
Something not right?
Check Questions and answers, or write to support@getgrafpoint.com saying which visual and where the report runs (Desktop, the Power BI service or Report Server), with a screenshot made with sample data.