Specify Workbook Filter Options

When you configure the presentation settings for a workbook, you can specify which options you want consumers to have when using the filter bar, for example, add filters or change filter values.

The options you set on the Workbook tab are carried over to the Active Canvas tab Filter Actions properties. You can override the Workbook tab's filter bar properties on any individual canvas.

All Filter Actions options are grayed out when the Full Interactivity option is set to Off. See Turn On or Off All Workbook and Canvas Actions.

1. On your home page, hover over a workbook, click Actions, and select Open.
2. From the Preview menu , select Configure Presentation.
3. In the presentation settings panel, click the Workbook tab.
4. In the Filter Bar section, deselect the filter actions options that you want to hide, or select the filter action options that you want to display.
   
   
   Description of the illustration present_workbook_filter_bar_options.png
   
   
5. Click Save.