Working with pivot tables

The pivot table element defines a table element with fixed roles and types for its columns. It is typically used for processing and aggregating multi-dimensional data.

What is a pivot table?
A pivot table summarizes, groups, and sorts the data in a report. Rearranging the columns pivots the data, displaying results in different ways.
Create a pivot table
Create a pivot table in a report, add dimensions and measures, and set additional properties as needed.
Organizing pivot table elements in the Structure view
The pivot table elements (pivot table, hierarchy/dimension, fact, and measure) must be organized within the Report Structure view so that values are triggered at the desired point in the data stream. There are varying methods for organizing your pivot table elements, but some methods are more efficient than others.