set analysis

[mambi]

Hi everyone,

from the table below i want to get in a text object the number of countries how don't have the value:  'music' in the Market list

Countries	Market
France	video games
France	music
France	books
France	tourisme
Spain	books
Spain	tourisme
Deutch	video games
Deutch	music
Deutch	books
Deutch	tourisme
Deutch	cars
Deutch	job

thanks

[Gysbert_Wassenaar · Accepted solution]

=count(DISTINCT {<Countries=e({<Market={'music'}>}Countries)>} Countries)

[agilos_mla]

Maybve not the most elegant way but it does the job:

=count(DISTINCT {<Country=E({<Market={'Music'}>} Country)>} Country)

Rgds,

Michael

[mambi]

Thanks Sir,