When production exceeds 100 Serial number, display the date

[#1]

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

[deepakk]

hi,

I have created without using set analysis. Please check the attachment. I hope this helps.

Deepak

[#3]

Thank you for you answer.

But it's not what I want...

I want to know when the fifth product was created but I may have 50 products ... So if(Count(Reference)=5,Max(Date))  does not work in this case.

if(Count(Reference)>=5,fifth date)  This might work but i don't know how to retrieve the 5th value.

[deepakk]

Hi,

Try out this application.

Deepak