Using Excel to filter exported FocalScope report data
Depending on your report filters, scope, and data range, FocalScope reports can contain an incredible amount of information. To make reviewing of report data easier, you can filter out data that is not part of your focus using Excel filters. This article details how to use Excel filters to fine-tune report data to only show information you are interested in.
Filtering data in exported FocalScope reports
After exporting a FocalScope report to an Excel file, you can filter the information contained in the report as follows:
- With the report open in Excel, click the [Data] tab
- In the ribbon, click the [Filter] icon. This will enable the filtering dropdown button to appear for all data fields in the report
- Click the [Dropdown] button on the data field where you want change the filtering of information
- Tick / untick the data types to show / hide the information show in the report. Please note, all report data fields depend on the collective information represented among them. Thus, changing one data field may impact the data show in other data fields.
Figure 1 - Filtering data fields in an exported FocalScope report