Thank you, Mayuresh!
Your solution works within the table, but I actually applied a different version.
Your suggestion got me there by getting me off the idea of substracting count to count distinct.
Instead, I now use count (aggr (sum(aggr (count (distinct A.text), A.id)), Team_Number))
I am a bit of an aggr-newbie, so I got stuck on using just one aggr-level in a pivot table and then got confused about the verying results all according to the filters applied. .
TEXT Flag A 1 B 1 C 0 total 2
The idea is to figure out, how many texts (which correspond to companies in my QV-data) overlap in various fields of business.
I found the solution: sum(aggr(if(Count(A.Text)<=1,0,1),A.Text)) as suggested by Mayuresh above works fine. My question was not sufficiently precise, I am a bit of an aggr-rookie... :-)
But as I needed an aggregation in a pivot chart, I had to use a second aggr level, else the results would vary according to the filters applied.
So, I used count(aggr(sum(aggr(count (distinct A.text), A.id)),Team_Number))
This may not be the most elegant solution, but it works.
Thanks for your help!