Chart Expression II

[JuanMu]

Hi All,
Is there any chart expression to calculate how many "Teléfonos" have more than one "Segmento" distinct?. For instance:

Teléfonos	Segmento
11111	RES
11111	PYM
22222	RES
22222	PRO
22222	PYM
33333	RES
44444	PYM
55555	PRO
66666	RES
66666	RES

The solution must be 2, "Teléfono" number 11111 and 22222 have more than one "Segmento" distinct.

Best regards,

Juan Muñoz.

[tresesco]

Try this:

Count(Distinct {<Teléfonos={"=Count(Distinct Segmento)>1"}>}Teléfonos)