| The Report Design Document / Working with Pivot Tables | |
When you define a pivot table, you set properties specific to 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.
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. In case that 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 so that if for example a pivot table with 4 dimensions and 3 measures is drawn as a category chart which has 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 Pivot Table: Pie, Pie3D, Ring, Bar, Bar3D, Area, StackedBar, StackedArea, Line, Line3D, Waterfall, Polar, Scatter, XYArea, XYStackedArea, XYLine, Step, StepArea, TimeSeries, Table