Pivot tables are matrix tables aimed to slice a measure with two or more dimensions.
Pivot tables are great for presenting aggregative data, but provide additional value for the data analysis as they use the x and y axes. This enables us to cross the data and compare two dimensions or more.
In order to understand the pivot table capabilities, we will use a basic structure: two dimensions and one measure object.
In the following pivot table, we will be able to analyze data by the Year or Quarter dimension. In the pivot body table, the revenue measure is presented as follows:
We can analyze each quarter ...