Pivot table FruitQ1Q2Q3Q4Apples6,9593,0267,26113,009Cherries931,2801,524151Peaches2683577,514805Pears1,4355213,3907,694Plums2342345,8481,482 Put one dimension down the rows and another across the columns, place a value at every intersection, and total the margins. The pivot table shows how one measure splits by two categories. Keep the dimensions few. Karsten on where the total belongs in a published table: “it is correct for a published table, as it places the most important item, the total, or whole, first before the reader’s eye” (Charts and Graphs, 1923). Also called: crosstab, cross-tabulation, contingency table From: Table Data as of 16:14 UTC on 20 Oct 2026 made withdbt Charts

Delete Dashboard

Are you sure you want to delete Pivot table? This will remove the file from the GitHub repository.

This action cannot be undone.

Keyboard shortcuts

  • Show this list ?