Filter column results shown in a pivot table

Filter pivot table column results in FLG Insights to quickly focus on specific data without having to re-run the report.

• Once you have run your report in the report designer, hover over the header of the column you want to filter to reveal a filter icon.
• Click the filter icon.
• Select the filter control from the drop-down list. Hover over the control for more information.
• Enter a filter value.
• Click Apply.
• The column filter will be applied to your report, shown by a purple underline in the column header.
• Additional column filters can be added to the same column by clicking Add another. Filters added to the same column use an AND expression.
• Delete individual filters by clicking the Remove (bin) icon, or click the Clear filter button to remove all filters on the column.

Tip: Column filters can be used in conjunction with report filters - this can be useful to filter on multiple fields.