Filters and Drilling

How a report's filter is changed while drilling depends on what part of the original report is selected when the drill is performed. By default, if an attribute element on the original report is selected while drilling, then that attribute element is added to the new filter created for the drill. The filter from the original report (the drilled-from report) is carried over as well.

For example, a report lists revenue by state and contains a filter for the Electronics category. A user selects Virginia when he drills to Store. The resulting report contains Electronics revenue for Virginia stores only.

You can change this default behavior for a drill path in the Drill Map Editor and for a report in Report Data Options. For descriptions of the drill path settings that affect filtering, see Drill Path Settings.