Returns the table without applying any context filters except for the area filter.
= FILTER.CLEAREXCEPTAREA(table)
table - The table object to return without any non-area filters, or Filter Input if this is a context filter.
Returns the table without applying any context filters except for the area filter.
= FILTER.CLEAREXCEPTAREA(table)
table - The table object to return without any non-area filters, or Filter Input if this is a context filter.