count distinct

[Anonymous]

Hey expert:

I need your help in a calculation. Somewhow I am not getting the right result. Please look at the table below. I want to calculate the count of distinct container which has both the Leg Type- SIngle leg and Multi leg. In below table it should be 2 as Containr B500 and A503 have both Single leg and Multi leg.

Container Number	Leg Type
B500	Single leg
B500	Multi leg
A500	Single leg
C501	Multi leg
A500	Single leg
A503	Multi leg
A503	Single leg
A503	Single leg

Any help is much appreciated.

[MarcoWedel · Accepted solution]

Hi,

solutions might be:

hope this helps

regards

Marco