Returns all of the rows in a table, ignoring any area filters that might have been applied.
= FILTER.CLEARAREA(table)
table - The table object to return without any area filters, or FilterInput if this is a context filter.
Returns all of the rows in a table, ignoring any area filters that might have been applied.
= FILTER.CLEARAREA(table)
table - The table object to return without any area filters, or FilterInput if this is a context filter.