Description
The pivot table presents dimensions and measures as rows and columns of a table. The pivot table allows you to analyze data by multiple measures and in multiple dimensions at the same time. The data in a pivot table may be grouped based on a combination of the dimensions. You can pivot by dragging and dropping dimensions in the table.
When to use it
The pivot table is particularly useful when you want to include several dimensions or measures in a single table, and then want to reorganize them to see different subtotals.
Advantages
The pivot table is very powerful when you want to analyze multiple dimensions and measures at once, and then reorganize them to get a different perspective on your data. Another advantage is that you can expand the rows you are interested in while keeping the rows in the rest of the table collapsed.
Disadvantages
The pivot table may seem a bit complicated, and does not give insights at a glance.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!