In data analysis and business intelligence, a pivot refers to the process of transforming data to create a summary or a new perspective on the original dataset. This is often done using a pivot table, which is a powerful tool that allows users to reorganize, summarize, and analyze data interactively.
Steps to create pivot table
- Select pivot table from the list of charts
- Drag and drop either categorical or date fields onto Rows drop zone
- Drag and drop either categorical or date fields onto Columns drop zone
- Drag and drop numerical field onto numerical drop zone
- Click on Get Result button
Example of a Pivot Table
| Date | Product | Category | Sales Amount | Region |
|---|
| 2024-01-01 | Widget A | Widgets | $200 | East |
| 2024-01-01 | Widget B | Widgets | $150 | West |
| 2024-01-02 | Widget A | Widgets | $300 | East |
| 2024-01-02 | Gadget A | Gadgets | $400 | West |
- Pivot Table Example: You might create a pivot table to summarize total sales by Category and Region.
| Category | East | West | Total Sales |
|---|
| Widgets | $500 | $150 | $650 |
| Gadgets | $0 | $400 | $400 |