Working with pivot tables The pivot table element defines a table element with fixed roles and types for its columns. What are pivot tables? A pivot table is a table element with fixed roles and types for its columns, suitable for processing and aggregating multi-dimensional data. Sample pivot table reports Two sample pivot table reports are provided with the installation of Genero Studio. One report shows a static pivot table, while the other shows a dynamic pivot table. Create a pivot table Create a pivot table in a report, add dimensions and measures, and set additional properties as needed. Pivot table properties The properties define the type of output and the display of the pivot table. Add a dimension to a pivot table The dimension of a pivot table specifies the columns that the data is sorted by and the values against which aggregation occurs. Dimensions are represented by the Pivot Table Hierarchy Value. Add a measure to a pivot table A measure is used to aggregate numeric values in a pivot table. Arrange your hierarchies Pivot table dimensions can be viewed as forming a hierarchy in the report structure. Arrange the hierarchies so that the values are triggered at the desired point in the data stream. Pivot table elements and the Structure view The pivot table elements (pivot table, hierarchy, fact, and measure) must be organized within the Report Structure view.