I have two list boxes, business1 & business2. I want a count of whether you are in business1, business2 or both.
I have the first two set up as follows:
count( {<business2=>} distinct ID) // gives me a count of those selected in business1 irrespective of what is selected in business2
count( {<business=>} distinct ID) //gives me the opposite count to above
Is it possible to use set analysis to give me the count of ID's who are in BOTH groups? In essence this gives me the figures one would see in a venn diagram.
