count held in common value

[omid5ive]

hi

i have a table like below

vendor	project
A	1
B	2
A	3
C	4
C	5
D	6

i want to know that ho many of my vendor work on more than one project; in this case in text box i need to see 2 because A and B work on more than one project

what should i do?

[shiveshsingh · Accepted solution]

try this in your textbox

=Count({<vendor={"=count(project)>=2"}>}distinct vendor)