What are summary view filters?
The Summary View offers powerful filtering capabilities that enable you to view only the required data. Zoho Reports allows you to filter data based on individual values, numeric ranges, date ranges, top 10, bottom 10 etc. It also allows you to apply multiple filters (based on multiple columns) on your report.
Please note, the filtering option discussed in this topic can be applied only when you are designing a summary view in Design Mode and not in View mode.
How do I add filters to the Summary View?
To apply the filters, please follow the steps below.
Click images to enlarge.
From the Summary View, click Edit Design.
Click on the Filters tab.
Drag and drop the column that you wish to add as a filter.
Select the values that you wish to filter. You choose to either include or exclude the data in the Include/Exclude Items shelf.
Select Click Here to Generate Summary.
The Summary View will now reflect only those results that fall within the filter.
Save your Summary View.