Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try this in your textbox
=Count({<vendor={"=count(project)>=2"}>}distinct vendor)
try this in your textbox
=Count({<vendor={"=count(project)>=2"}>}distinct vendor)