Value-based Filters
Value-based filters let you filter the data in your workbook visualizations using specific values from any field you've added to the Layout panel or Table Viewer. In pivot tables, value-based filters apply to every row and column, and remove any that don't contain the selected value. In charts, any columns, bars, or lines that don't contain the selected value are removed from the results.
To apply a value-based filter to a workbook visualization:
-
Click the Field Menu icon
next to any field in the Layout panel or Viewer and select Filter [Field Name]...The Filter window appears.
-
In the Filter window, select the field values and operator to use in the filter condition.
-
(Optional) In the search box, you can enter the value you're looking for.
-
Click OK.
The results update, and the selected filter criteria shows above the Viewer.