Pivot table
Pivot tables summarise data into a grid, letting you arrange dimensions into rows and columns with measures aggregated into values. They’re useful for breaking down data by multiple categories, spotting patterns, or comparing across groups.
Template options
Basic pivot table → displays rows, columns, and aggregated values.
Pivot table with color → adds conditional formatting to highlight differences or ranges in the data.
Mapping options
Rows → Dimension(s) to group along the vertical axis. Multiple fields can also be added here, with order controlling the hierarchy.
Cols → Dimension(s) to group along the horizontal axis. Multiple fields can also be added here, with order controlling the hierarchy.
Values → Measures to aggregate (sum, count, average, etc.).
Color → Applies conditional formatting to values.
Tips
Pivot tables are best when exploring relationships between multiple dimensions.
If you just want to show a straightforward table of data (without pivoting), use a Table low-code cell instead.
Last updated