Enabling and disabling filters and sorts
The
check box enables or disables all filters and sorts in the Filter and Sorting panes. But you can enable or disable them individually.To disable a filter or sort, click it and select Edit Formula dialog.
from the Enabled list in Filter Settings or Sorting Criteria Settings. Or, use a formula or variable by selecting from the Enabled list. Specify the formula in theFor example, in the Edit Formula dialog
you might reference a global variable that contains the values True
or
False
.