You can use the pivot control in Classic Designer to customize the layout of a report. The pivot control is useful for rearranging rows and columns in a report. The pivot control has three quadrants used for positioning in the report: Column, Rows and Measures. Changes you make in the pivot control are applied to the report table immediately.
To create a pivot table in Classic Designer, you must create a report with at least two attributes and one measure.
To use the pivot control to change the layout of a report
-
In Classic Designer, open the report.
-
Click the Pivot Control icon
at the top of the page.
The Pivot Control opens. -
Drag elements from one quadrant to another to reposition the elements in the report.
For example: By default, measure labels are displayed on column headers. To display measure labels on rows, drag and drop the Measure Labels element from Column to Rows. -
Drag elements within a quadrant to change the display order of the columns in the report.
-
To remove a column from the pivot table, drag it out of the pivot control onto the Subject Area.
-
Click the Options button in the Pivot Control to show or hide labels and control auto sizing.
-
Close the Pivot Control by clicking the x at the top of the control.
-
Click Report - Save.
Tips:
You can click on an element in the pivot control to access the options menu for the column.
If an element in the pivot control is blue, this indicates it is being used as a trellis attribute for trellis charts.
When creating a new report, if you drag an attribute or measure from the Subject Area to the Results area on the right, the pivot control will automatically open enabling you to place the attributes and measures in one of the three quadrants for positioning in the report.