Pivot tables (similar to Excel Pivot Table) are an effective visualization that allows you to present and summarize your data through dragging and dropping the columns and rows from a result set without changing a chart's SQL.
The pivot table is necessary when you want to summarize a large amount of data in a single table (report), and then want to reorganize them to see different subtotals.
- Run your report SQL query to return all the needed dimensions and measures field columns.
- Select Pivot Table on the right-side panel
- Drag and Drop fields to Rows, Columns and Values in Pivot Settings