3 Replies Latest reply: Feb 15, 2012 8:09 AM by Deepak Kurup RSS

    When production exceeds 100 Serial number, display the date

      Hello everybody,

       

      I have a problem I can not solve. I think we should use a Set Analysis.

       

      Here is my table:

       

      Serial Number              Date             Reference

      00001                      01/10/2010             A

      00002                      05/10/2010             B

      00455                      25/11/2010             A

      15102                      30/11/2010             A

      48520                      02/12/2010             A

      15621                      03/12/2010             B

      15672                      08/12/2010             A

      65421                      01/01/2011             A

      15642                      25/01/2011             B

      23486                      15/03/2011             B

      15674                      14/06/2011             A

      15244                      01/11/2011             A

      57869                      02/11/2011             A

      46571                      15/01/2012             A

       

      What I would like to know it's the date on which a reference has been more than 5 products Serial Number:

       

      Approximately:

       

      When count (Serial Number) = 5 then

                       DATE

      Group by Reference

       



      For the Reference A, i want : 08/12/2010

      For the Reference B, i don't want a Date because I have 4 SN.

       

       

       

      I want this in a PivotTable.

       

      In my dimension I would have Reference and in my expression my date.

       

      Please help me.

       

       

       

      (sorry for my bad English ...)

       

      Regards.

       

      Cyril