Contact, if you are interested in this website / development / Sponsorship / Advertisement / Partnership β†’

Pivot Table

Summarise thousands of rows into a compact table in seconds. Choose what to group by, what to measure and how to aggregate.

πŸ“‚ Drop a CSV or browse

Layout

How to use the pivot table

A pivot table groups rows that share a value and summarises a measure for each group. Pick a Rows field (for example Region), an optional Columns field (for example Quarter), and a Values field with an aggregate (for example Sum of Revenue). Grand totals are calculated from the underlying rows, so averages and distinct counts stay correct. They are never an average of averages.

  • Count counts non-empty values. Use it with any field to count records.
  • Distinct count counts unique values, such as unique customers per region.
  • Numbers formatted with currency symbols or thousands separators (like $1,200) are understood automatically.

New to pivots? Read Pivot tables explained.

Want this as a live dashboard?Get a dashboard built