Pivot table properties

The properties define the type of output and the display of the pivot table.

Select the object on the Report Design page to display its properties in the Properties View. You can change the object's default appearance by setting the values of its properties.

In addition to the attributes available for LAYOUTNODE, the PIVOTTABLE element includes the following properties:
  • Title - The title of the pivot table.
  • Draw As

    The drawAs property specifies the type of output that is rendered from the data. Depending on the type selected and the number of available dimensions, the rendering is delegated to the map chart, category chart, XY chart or table element. If the number of selected dimensions outnumbers the respective number in the selected visualization, the exceeding dimensions and measures are ignored. The values are assigned from left to right. For example, if a pivot table with 4 dimensions and 3 measures is drawn as a category chart with only 2 dimensions and one measure, then the chart will be drawn using the first two dimensions and the first measure from the pivot table's columns. Selecting Table causes the output to be drawn in tabular form, displaying all selected columns of the pivot table.

    Valid values for drawAs for Pivot Table: Area | Bar | Bar3D | Line | Line3D | Pie | Pie3D | Polar | Ring | Scatter | SpiderWeb | StackedArea | StackedBar | Step | StepArea | Table | TimeSeries | Waterfall | XYArea | XYStackedArea | XYLine. The default is a Table.

  • Compute aggregates on the innermost dimension - Whether to compute aggregates on the innermost dimension.
  • Hierarchies input order - The order by which the data is presorted.
  • Display selection - Which of the declared dimensions or measures to display.

    Not specifying a value is equivalent to selecting all declared dimensions. For example, given a table with three dimensions, not specifying this attribute is the equivalent of specifying a value of "0,1,2".

  • Display recurring dimensions - Whether recurring dimension values in the same column of table output should be displayed.
  • Range Upper Bound and Range Lower Bound - The highest and lowest values on the Y-axis.