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 reportsTwo 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 tableCreate a pivot table in a report, add dimensions and measures, and set additional properties as needed.Pivot table propertiesThe properties define the type of output and the display of the pivot table.Add a dimension to a pivot tableThe 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 hierarchiesPivot 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 viewThe pivot table elements (pivot table, hierarchy, fact, and measure) must be organized within the Report Structure view.Related conceptsPivot table library