By applying Filters to Reports in your CRM, you can narrow down your Report results to focus on specific types of data that you're interested in. Filters can be applied to both pre-made Reports and Reports that you've built yourself.

To add a Filter to your Report, simply click on the further options (three dots) and select 'Filters'.

A side panel will appear which will detail any Filters which are already applied to the Report, such as Status Flag which by default excludes any deleted records from your results.

To add a new Filter, click the 'Add Filters' button, and a list of fields will appear relating to the Report entity selected.

Simply select the fields that you wish to apply the Filters to e.g. Account Manager and Estimated Close Date. Once happy with your selection, click 'Continue'.

Note: You can also use the search bar to quickly locate the field you are looking for by typing the field name.

Your selected Filters will then be added to the Filters sidebar, and we can now set the parameters for each Filter. In this example, we only want to view Opportunities that have David Smith and Julie King set as the Account Manager. As you select the parameters for the filter, the results will be filtered on the report.

Within date Filters such as Estimated Close Date, you'll have a range of date parameters to choose from such as 'In the Last Year', 'Between' two dates or a 'Specific Year'. This allows you to achieve even more precise filtering.

​

You can also individually configure each column to sort data, add filters, add/remove columns, or modify the column's properties (e.g. change the format of the date). Simply hover over the column name that you want to edit and click on the further options menu (three dots to the right) to get the drop-down of options to edit this column.

Once you've applied your required Filters, remember to save your changes to the Report before you close it. Simply click the save icon in the top right-hand corner.

If the Report is completely new, you'll need to give it a name and choose whether to save it just for yourself or make it available to all CRM users. Once happy with your changes, click the 'Save' button.

To make it easier to access the Filter menu and see what filters are applied to a Report, simply pin this menu. Not only does this make for quick and easy access, but it allows you to manipulate the filter and subsequent results more quickly too. For example, if you had a filter of 'Account Manager', pinning the Filter menu makes it easy to switch the Account Manager and therefore change the Report results.

Navigate to the further options menu (three dots) on a Report in the top right-hand corner. Select the 'Filter' option to open this menu.

Select the pin icon in the top right-hand corner of the Filter menu.

This will change the view of the Report and embed the Filter menu. You can easily unpin this by selecting the pin icon again.

Note: Pinning this menu will only apply on a per-report basis.

To make it easier to access key filters and hide any static filters, you can favourite certain filters. By marking a filter as a favourite, the filter menu will automatically be pinned and will only show the favourited filters initially. By only showing the favourite filters, you can now easily wield dynamic filters on a more complex Report without having to find them.

Note: You can unfavorite back the filters if you don’t wish them to be pinned.

Navigate to the further options menu (three dots) on a Report in the top right-hand corner. Select the 'Filter' option to open this menu.

Select the heart icon in the top right-hand corner of the filter.

This will then change the look of the Report when you initially open it.

When opening the Report, you'll now only see your favourite filters initially. To see all filters applied to the Report, select 'Show all Filters' at the bottom of the Filter menu.

Note: The favourite filters will only apply on a per-report basis.

A great example of a Report with favourited filters is our 'Customers who bought X but not Y'. Learn more about this Report here!