I have a dataset like the table below (larger though):
Now I made subfields for 'Business function' and 'Name' like this:
SubField("Business function", ';') as Tags,
SubField("Name", ';') as Tags2,
The following problem now occurs when I want to count the Business function or Name:
This would mean that even with the set analysis below my business function Tok, Kok, Bok is still counted twice. And Stone, Bone, Home is counted tree times if I am correct:
count(aggr(sum(DISTINCT [Tags]), [ID]))
count(aggr(sum(DISTINCT [Tags]), [Tags2]))
I somehow want to combine the DISTINCT ID and Tags2 but I don't know if that is possible. Does anyone have a clue what I am talking about and would show me the solution (A)?
Would be great help if anyone knows how!!!
can you please send the screenshot of what you want the end result look like?
May be this:
Sum(Aggr(Count(DISTINCT Tags), Tags2, ID))
First of all tnx for the quick replies . I want the following but I just want this to happen in the set analysis:
Sunny T I will try yours in a sec, it might be the one I am looking for.