Is there a way to create a dynamic set based on sales in one year, and be able to display sales data for all years in the view. I can create a set with a condition like this:
(max(IF [Order Date]>=#1/1/2012# THEN 1 ELSE 0 END)
max(IF [Order Date]<=#12/31/2012# THEN 1 ELSE 0 END)
But it doesn't work. I want to be able to display the set of performers with sales over $1,000,000 in 2012 and their sales in 2012 AND 2013. It would be easy to accomplish this with a static set. But the set need to be dynamic and easily modified with parameters.