Working with Data Pane Columns
The default columns and their arrangement are determined by the report type and the currently selected layout (see Working with Report Layouts).
Showing and Hiding Columns
- In the Data pane header, click , and then click Show/Hide Columns.
- Select or click to clear column check boxes, and then click Done.
Arranging and Sorting Columns
To change column order, drag a column to a different position.
Note: Columns currently selected as groupings (see Grouping by Column Data) are locked in place and cannot be rearranged.
To change the sort order of data in a column, click the column heading to display the current sort order (up or down arrow), and then click it again to reverse the order.
Working with Column Filters
You can use filters to refine report results to include only those records that match certain column data criteria.
- In the Data pane header, click , and then click Show Column Filters.
- (Optional) By default, a filter will include only those records whose filtered columns contain the text you specify or are equal to the date you specify. Do one of the following:
- To change a text column's filter criterion, point to , and then click Does not contain, Starts with, Ends with, Equals, or Does not equal.
- To change date column's filter criterion, point to , and then click Does not equal, Less than, Greater than, Less than or equal to, Greater than or equal to, or Between.
- Do one of the following, depending on the column type.
- For columns containing text, start typing text in the filter box. The filter is immediately applied as you type.
- For columns containing dates, click , and then select a date. (If the filter criterion is Between, select both a start and end date.)
To clear a filter, point to , and then click Reset.