counting problem

[#1]

Hi! i'm working on this project and i want to crate an object that shows me only the number of 'controllo' that have 'Numero Domanda'= 1. i try to do this with a pivot table where in the expression i inserted the following condition "count(distinct(Domanda))" it works, but i want to see the number of controllo that have 'numero domanda' =1 .How i can solve this problem??

[MK_QSL]

COUNT(Aggr(COUNT({<Numero_Domande = {1}>}Distinct CONTROLLO),CONTROLLO))

or

Simply

COUNT({<Numero_Domande = {1}>}Distinct CONTROLLO)

[sicilianif]

Use set analysis. Something like this

count({<Numero_Domande={'1'}>} distinct Domanda)

[maxgro]

maybe with a calculated dimension

=if(aggr(sum(domande),controllo)>1,null(),controllo)

and check Suppress when value is null