Top Gradient
← Back

Slice and drill into any metric with Pivot Tables

Monday, October 05, 2026

  • Author
    Ian YangProduct Engineer @ SELECT
  • Author
    Cherrie LamProduct Designer @ SELECT

Pivot any table by rows and columns, right from the column header. Break down any metric, like spend by warehouse per day of the week!

Not exactly what you want? Choose your row and column dimensions, and fine-tune the pivot from the Table Configuration side panel

Want to start from the big picture and only drill in where it matters? Turn on collapsible rows from the table header, or from the table settings panel!

With collapsible rows, tables start collapsed at the highest grouping level. Drill down by expanding any row to break it down by the next dimension

And don't worry: even if you're not pivoting, collapsible rows work on regular tables too!

Wish you breakdowns lived on your team's dashboards? All of this works in Custom Dashboards too! Pivot right from the block editor and/or turn on collapsible rows, building drillable summaries right into your dashboards

Up next.Previous Changelog Entries.