Format pane
Data & Features
Control the rendering mode, the cell load limit, value-column sorting, and Top/Bottom N filtering with its optional toolbar button.
Mode and loading
| Setting | What it does |
|---|---|
| Mode | Chooses the rendering strategy. Performance mode uses paging and virtualisation, which keeps large matrices responsive by drawing rows as they come into view. |
| Cells to load | Caps how many cells are fetched and rendered at once. Raising it shows more without scrolling but costs memory and render time. |
| Sort value columns | Allows readers to sort the matrix by clicking a value column header. |
| Sort column grand total | Allows sorting by the column grand total rather than an individual column. |
Top/Bottom N
Top/Bottom N reduces the matrix to the highest or lowest ranked members, optionally rolling everything else into a single Other row so the totals still add up.
| Setting | What it does |
|---|---|
| Show | Off, top N, or bottom N. |
| By | Whether ranking is by value or by another basis. |
| N | How many members to keep. |
| Based on | Which field decides the ranking. |
| Apply to | Which part of the matrix the filter affects. |
| Show remaining as Other | Rolls the excluded members into a single row instead of dropping them. |
| Other title | The label for that row. |
| Show count | Appends the number of members rolled up into Other. |
| Add to toolbar | Gives readers a button to switch the filter on and off themselves. |
When Add to toolbar is on, a second group appears with the button's own text, icon, size, corner radius, font, colours, and border — the same styling controls every toolbar button has.
Screenshot placeholder
Top/Bottom N with an Other row
A matrix filtered to the top 10 members with the remaining members rolled into an Other row showing a count.