Follow this procedure to create a static pivot table.
-
Create a new, empty report.
-
In the Data View, associate your data schema.
-
From the Tool Box, add a Pivot Table to the report layout under the Page Root.
-
Add dimensions as Hierarchy elements. See Add a dimension
-
Add measures under the Fact node. See Add a measure.
-
Arrange the dimensions and measures in the Structure View. See Arrange your hierarchies.
-
Set additional properties as needed for all elements of the Pivot Table. See Pivot table properties
An example is provided in the Reports project (Reports.4pw), provided as
part of the samples directory. The report is
StaticPivotTable.4rp.