← All articles

Reports & charts — Cross-tab: group down the side and along the top

Set a second group column and a report becomes a cross-tab: the first grouping runs down the side, the second along the top, and one measure fills the grid — revenue by region by quarter, in a single table. Choose the measure under Matrix measure; it is deliberately one number, because a cell holding six columns is a spreadsheet rather than a cross-tab. An empty cell reads —, never 0: nothing landing there is a different fact from a measured zero, and the CSV exports it empty for the same reason. Row totals, column totals and the corner are all computed over the records themselves rather than by adding up the cells, so an average column doesn't turn into an average of averages.
Nothing here answered it? Ask us directly — we usually reply within one working day.

Made with RowFold