Filtering
Filtering information is used when you require to only bring up specific inform or to exclude information.
This can be used for:
- Showing only specific, required information
- Excluding unrequired information
Basic Filtering
In your report, in the filter box of the subject you would like to filter, type what information you would like filtered. For example in Zone/Area if you require only information relating to Mortlake Campus, type Mortlake and this will automatically generate all information relating to this category.
To change the filtering information, once you have entered the information, click on the filter button. This will give you a list of pre-existing filters. Click on the filter option you require.
Advanced Filtering
In your report, click on the 'Create Filter' button. This is located on the bottom of your report, on the bottom bar.
NOTE: Advanced Filter is used in conjunction with the basic filter. Use advanced filtering after you have typed in the basic filter, for example Zone/Area Mortlake Campus.
The Create Filter button will bring up the 'Filter Builder'.
In the filter builder you have a couple of options. If you click on 'And', you can choose to add or exclude additional information to the set basic filter. To change this from 'And' click on 'And' and choose 'Not' or 'and' or any of the other options by clicking on them.
In this example if you wanted all information for Mortlake Campus AND Avery House. You don't have to change the And, you just click the 
Once you have clicked on the + button this will bring up options depending on your request. In this example, as we have previously typed in Mortlake Campus in the Zone/Area, it has brought up 'Zone/Area' and 'Begins with' as these were the preset basic filter we choose. You can change any of these presets by clicking on them.
