9 Replies Latest reply: Apr 26, 2012 9:55 AM by Jason Michaelides RSS

    Dashboard: The new clients customers of the month

    Laurent Berrebi

      Hello

       

      My problem seems not so complex but i haven't find the good solution !!!

      Help please.

       

      I need to report in my application the new client of the month (or year)

      After selecting the year, the month I would like to show all new clients (where never exist before the selected month/year)

       

       

      Have a look in the attach file

       

      Warm thank for your help.

       

      Data is this one:

      Year,             Month,   Client Name

      201112     A
      201112     AA
      20121     A
      20121     B
      20121     C
      20122     B
      20122     C
      20123     B
      20123     C
      20123     D
      20123

           E

       

      if I select 2012, and month = 1, then i need to show in the list box "New clients" with B, C
      if I select 2012, and month = 2, then i need to show in the list box "New clients" with Nothing (empty list), or "No new client this month"
      if I select 2012, and month = 3, then i need to show in the list box "New clients" with D, E

      and if possible (nice to have)
      if I select 2012 only with no selection on the month, then i need to show in the list box "New clients" with B, C, D, E

       

       

      Hope i'm clear enough.