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 which can be useful to filter on multiple fields.
Let us know how we can improve FLG on our feedback site.