How to write this set analysis?

[#1]

Hi All,

I have the following table:

CustomerId Code

1, EN

1, GE

2, EN

I want to get how many Customers have both EN Code and GE code.

It is clear that just Customer 1. How to use count function to get it?

Many thanks.

[jvitantonio]

Try something like this:

=count (distinct {$<CustomerID = P ({1<Code={"EN"}>} CustomerID ) >*<CustomerID = P ({1<Code={"GE"}>} CustomerID ) > } CustomerID )