Using Aggr + If and Set Analysis

[agigliotti]

Hello,

I have the following expression in straight table:

count( {< [LF tipo budget] = >} DISTINCT

aggr( if(

sum( {< _FATTURATOFlag = {"S"}, [LF tipo budget] =, _FATTURATO_YTD_APFlag = {"S"} >} [Importo netto riga] )>0,

[%Codice cliente], null()),

$(vDimGrpResoGroup), [%Codice cliente] ) )

It works well, but I need the expression to be not affected from the selection on field named "LF tipo budget".

Can anyone help me to achieve it ?

Thanks in advance for your time.

Best Regards

Andrea

[Anonymous]

Did you solve this?

If so, how?

[agigliotti]

I solved separating the table with "LF tipo budget" from the cloud.