What are Pivot table filters?
A useful feature of pivot tables is that you can filter columns, to display only required data. Zerion Reports allows you to filter a column for specific ranges, individual values, date ranges, etc. depending on the data type of the column.
How do you apply filters on a Pivot table?
Zerion Reports offers various filtering options like filter based specific numeric ranges, date ranges, individual values, top 10, bottom 10, etc. You can also apply multiple filters (based on multiple columns) on a Pivot table.
To apply filters to your Pivot table, please follow the instructions below.
Click images to enlarge.
With your Pivot view loaded, click the Edit Design button.
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 Pivot.
The Pivot Table will now reflect only those results that fall within the filter.