About data filtering
A cross tab often displays more data than you need. Using Data Analyzer, as you add or manipulate dimensions and measures, the number of cross-tab rows and columns can increase to a size too large to view on the screen or print on one page. You can improve the usability of the data if you limit the amount of data. A primary advantage of presenting data in a cross tab is the ability to analyze and compare data values, ideally on one page or screen.
Using a filter, you can display values in a cross-tab, based on specific criteria. For example, instead of listing all customer sales, you can create a filter to list only the sales data for a particular week or a specific region. Filtering data helps you work effectively with large amounts of data. It enables you to present the information that answers specific business questions, such as:
*
*
*
Using Data Analyzer, you can filter data at the cross-tab level to narrow the data scope in a cross tab and also to remove unwanted data fields that show too much information. You can also filter data in specific dimensions and measures.
Applying a filter can limit the ability to drill up to summary data or drill down to detailed data. When you apply a filter, consider which values you want to view and the trends or relationships that you want to analyze. If you save a cube view (.cubeview) file or a report document (.rptdocument) file, and provide it for another user to analyze, consider how any filters you applied limit that user’s ability to drill up or drill down in the data hierarchy.
When you apply a filter, you can select the option, Recalculate Totals, which makes Data Analyzer recalculate totals based on the filter you apply. The recalculated totals are a subset of the totals before applying the filter. For example, if a cross tab displays totals for columns and rows and you apply a filter and select Recalculate Totals, Data Analyzer recalculates the column and row totals to show the aggregate values for the filtered data. The Recalculate Totals option is selected by default.
If a cross tab displays totals for columns and rows, and you want those same totals to appear for you to compare to the filtered cross-tab data, deselect Recalculate Totals. The cross-tab displays columns and rows based on the filter you apply, but the totals do not change.

Additional Links:

Copyright Actuate Corporation 2012