How to Drill Down to Specific Information
The Drill Down feature gives the User a better understanding of their data and can be used as an analysis tool. For summary and matrix reports, filter selected rows by a particular field. Select the rows you want to view, choose a field to group by, then click Drill Down. In this lesson we will learn to drill down to get more specific information. Using the Drill Down Feature allows you to get more specific information.
This allows you to use one stock report that has the fields you are interested in, and get a lot of different answers from it - without creating and saving a seperate report.
Find a report you want to work with.
Group the Report
Choose the summary fields you want to work with.
Choose your Drill Down Field
Check your results
The Drill down created a filter for the State = CA (See the Filtered By: at the top of the Data) and then grouped by the Drill down. I know this is working because the total number of records is 55. I can now choose to show the detail, or I can drill down further by checking the rows I want to see and creating another drill down. I want the bottom 5 Impact Areas and I want to see What cities they are in.