This is how you define which fields are used in the report, the order in which they appear, and if you want them to display as a row, column, or an aggregate.
Navigation Pane Display
Column Labels (ACROSS)
Add fields to this pane to create column labels in the report.
Row Labels (BY)
Add fields to this pane to sort the report in the order the fields are listed.
Measure
Add fields to this pane to control the action for each row. A measure is a numeric value that you may want to aggregate. Sum will add up the values of all the rows that have matching data in the fields listed in the BY pane. Print will display each row, sorted by the fields listed in the BY pane.
- To modify the display commands, click on the dropdown arrow, to the left of the Measures label.
- Click to select PRINT from the dropdown menu.
Filter
For additional information regarding Filters, refer to the Filtering a Report documentation.
Adding Fields
Drag and drop individual fields from the left navigation (Data) pane, to the work area palette. The fields will be dropped into the work palette and the sample data values appear in the Live Preview pane.
Alternatively, highlight all of the fields, from the left navigation pane, and drag them at the same time to the PRINT area section of the work area palette.
Related Articles