SETFILTER

You can enable or disable filters using this function. Note that the filter should already have been created to be able to refer to it in the function.

Syntax

SETFILTER(FILTER.FILTER_NAME)

Arguments

FILTER_NAME - The name of the filter to be enabled.

Example

SETFILTER(FILTER.[Filter_Office_Tech]) #Applies the specified filter

Set filter

CLEARFILTER

Syntax

CLEARFILTER()

Example

CLEARFILTER() #Clears any applied filters

Clear filter