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:

       

      (sum([Sales])>1000000

      and

      (max(IF [Order Date]>=#1/1/2012# THEN 1 ELSE 0 END)

      +

      max(IF [Order Date]<=#12/31/2012# THEN 1 ELSE 0 END)

      =

      2)

       

      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.