Thanks for your reply.
I have my activity table where I have column A and B. What I want to do is know the number of elements of A that have associated more than 1 element of B. In this way, I used the component ‘Number’ with the following formula ‘COUNT (DISTINCT “ACTIVITIES”. “A”)’. To get not only the number of elements of A, but the number of elements of A with more than 1 element of B I thought of filtering the component with the following formula 'FILTER COUNT (DISTINCT “ACTIVITIES”. “B”) > 1 '. However, I got the error that I can not filter with an aggregation function. Can you tell me what I should do to get the result I want?
Thank you in advance for your help.