Filter Data

A filter changes the focus of a report by limiting information to a level of a dimension and emphasizing only the information you choose. If you want to examine the impact of a single aspect of your business on the whole, you can filter to the lowest-level category in that dimension.

For example, a report shows revenue in all locations for all product lines. You filter the report to show revenue for only Americas product lines. The following illustration shows a report with revenue for all product lines sold in all locations.

The following illustration shows the same report filtered on Americas in the Sales Staff dimension. The revenue changes to show values for Americas only, even though Sales Staff is not currently set as the rows or columns of the crosstab. In the dimension line, Americas has replaced Sales Staff.

Steps

1. In the dimension viewer, locate the category you want to filter on.
2. Right-click the category, and then click Filter.

The filtered category appears bolded in the dimension line and, in the display, the values change to reflect the filtered category.

Tips

• To add a filter from the dimension line, click the dimension, and then click the category you want to filter on.
• To remove a filter, click the filtered category in the dimension line, and then click the dimension level.
• To remove all filters from all dimensions, click the Reset Dimensions button on the dimension line.
• To page through layers filtered on each sibling of the filtered category, click the highlighted area over or under the name of the filter. You can use layers to create a different perspective of your data when you export to .pdf file .