I want to create a set analysis for three selections saved as bookmarks (Set1, Set2, Set3).
In my example, I have created three tables of data which are linked by field [nr].
My problem is that I can not do set analysis and calculate the number based on the key [nr]. Instead, I have to use the respective [nr1], [nr2] and [nr3] for correct set analys result.
Set1:
1,2,3,4,5,6
Set2:
1,2,3,7,8,9
Set3:
3,4,5,7,10,11
Count({Set2*Set3} DISTINCT [nr]) = 1 (should be 2)
Count({(Set3*Set2)} DISTINCT [nr2]) = 2 (this i correct)
Is it not possible to make set analysis and count the number of a key field?
