Question
How 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.
DATEPART('month', [Order Date]) = DATEPART('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])