Let’s say you have a sales dataset with columns: Sales Platform (Column A), SKU (Column B), and Quantity Sold (Column C).
To create a pivot table summarizing total sales per platform and SKU, follow these steps:
- Create a Dashboard and add a Pivot Table Widget.
- In the widget configuration:
- Row Dimension: Select Sales Platform (groups data by platform).
- Column Dimension: Select SKU (groups data by product SKU).
- Summary Metrics: Add Quantity Sold and set it to Sum (or choose Average, Max, Min for other calculations).
- Click Save to generate the pivot table.
You’ll now see a table showing total sales (or other metrics) grouped by platform (rows) and SKU (columns).
