By default, when you make a change in a filter on a sheet, data in the sheet is updated automatically. The data is updated again when you make another change. You can change this behavior so that you control when the update occurs. Applying a number of filter changes all at once can be helpful when your sheet contains large amounts of data, so that you update the data once, after all the changes are made. Updating the data repeatedly takes longer than updating it once.
When filter changes are applied all at once, the Filter panel displays Reset and Apply buttons, as shown below. After you make choices in the filters in the Filter panel, click Apply to update the data on the sheet.
This setting applies to all filters in the Filter panel, that is, all filters for the displayed sheet.
You must have Edit Dashboard, Create Dashboard, and Run Dashboard privileges.
To determine whether filter changes are applied individually or all at once:
Click the name of the dashboard to run it.
Click the tab of the sheet to modify.
If the Filters panel is not displayed, from the View menu, ensure that Filters Panel is selected. If the Filters panel is hidden behind another panel, click the Filters icon to display the Filters panel.
Hover the cursor over the Filter panel, then click the arrow icon displayed in the top right of the panel. Do one of the following:
To update data each time that you make a selection in a filter, select Auto-apply Filters (default).
To update data when you click Apply in the Filter panel, clear Auto-apply Filters.
Creating filters for a sheet of data
Limiting the data displayed in a dashboard: Filters, sheets, and pages
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices