Finding occurences of events

[nicolai_moller]

Hi

I have 3 fields:

ProcessArea     ProcessProduct     Date

P1                   A                         1/1-13

P1                   B                         2/22-13

P1                   C                         2/24-13

.

P2

.

P(n)

In each processArea, the process should allways start with product A, then B, and then C, as shown in the table.

How do I find all the occurences of where ex. product B has been produced before product A in each processAreas?

thanks

[Gysbert_Wassenaar · Accepted solution]

In a straight or pivot table with ProcessArea as dimension you can try this expression: if(FirstSortedValue(ProcessProduct, Date) = 'B' , 'B before A').

edit: maybe this is better as it catches more cases: if(min({<ProcessProduct={'B'}>}Date)<min({<ProcessProduct={'A'}>}Date),'B before A')