Pivot in Designer

Use the pivot control in 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 made in the pivot control are applied to the report table immediately.

To create a pivot table in Designer, you must create a report with at least two attributes and one measure.

  1. From Designer, open the report.
  2. Click the Pivot icon.
  3. Drag elements from one quadrant to another to reposition the elements in the report.
  4. Drag elements within a quadrant to change the order of the columns in the report.
  5. To remove the column from the pivot table, drag it out of the column area or click the more actions icon and select either Don't pivot on column, to keep the column in the report, or Delete to remove it from the report.
  6. By default, measure labels are displayed on column headers. Click the More Options button in the Pivot Control to show or hide labels, control auto sizing, and show measure labels in columns or rows.