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

CLEARFILTER#

Syntax#

CLEARFILTER()

Example#

CLEARFILTER() #Clears any applied filters