0 Replies Latest reply on Sep 6, 2013 5:45 AM by N A

    Tricky SET condition based on date range, displaying all dates

    N A

      Hi all,


      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.


      Thank you in advance for your suggestions.