Help With Set Analysis

[#1]

Hi everyone,

I am trying to calculate the number of Items where an Item with PCatID = 2 or 3 or 4 comes after PCatID =1. (please see the attached document)

I think I could use a set analysis expression that evaluates as:

count(ItemID) where max(creationdate) for PCatID=2,3 or 4 is greater than max(CreationDate) with PCatID=1.

How can I do this straight and simple?

[file attached]

Regards and Thanks,

-Khaled.

[#2]

Dear,

Stepan.

Thanks for your help.

The above solution is working fine.

Thanks,

Mukram.

[#3]

Dear Stefan,

Thanks a lot for your help. It's fixed now.

Regards & Thanks,

-Khaled