QuestionHow to filter the view differently based on a parameter value.
For example, swapping between filtering the view to see sales for this month or sales that were over $1000.
DATETRUNC( 'month', [Order Date] ) = DATETRUNC( 'month', TODAY() )
[Sales] > 1000
( [Choose a filter] = "sales this month" AND [Sales this month] ) OR ( [Choose a filter] = "sales over $1000" AND [Sales over $1000])