Pivot Table

The PIVOTTABLE element is the enclosing element of an abstract pivot dataset that can be used for creating a variety of multidimensional outputs such as tables and charts.

Pivot Table is found in the Business Graphs group in the Tool Box view.

The resulting data is drawn into a box defined by X-Size and Y-Size. If these are not defined, the view expands to whatever space it can claim in the parent.

The PIVOTTABLE element is part of the Business Graphs group in the Report Designer Tool Box.

Depending on the visualization type (specified by the drawAs property), the output may span several pages. For these visualization types (such at Tables), the enclosing containers should support propagation.

Properties

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 has the following properties:
  • title
  • drawAs

    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.

  • fidelity

    The fidelity property applies only if the chart is drawn as a table (drawAs="Table").

  • computeAggregateInnermostDimension
  • hierarchiesInputOrder
  • displaySelection
  • displayRecurringDimensions