Create a pivot table

Create a pivot table in a report, add dimensions and measures, and set additional properties as needed.

  1. Create a new, empty report.
  2. In the Data View, associate your data schema.
  3. From the Tool Box, drag and drop a Pivot Table to the report structure under the Page Root.
  4. Add dimensions as Hierarchy elements. See Add a dimension to a pivot table.
  5. Add measures under the Fact node. See Add a measure to a pivot table.
  6. Arrange the dimensions and measures in the Structure View. See Arrange your hierarchies.
  7. Set additional properties as needed for the Pivot Table. See Pivot table properties.
  8. Save the report.

Examples are provided in the Reports project (Reports.4pw) as part of the samples directory. The reports are StaticPivotTable.4rp and DynamicPivotTable.4rp.

Note: You can create a dynamic pivot table by calling the Pivot library APIs.