Conditions in table's dimension

[danimarc12]

Hello everyone!

I have an issue with my App. I want to display my first column Clienti  with the condition that Saldo periodo and Saldo prec are <> 0. So my expected records should be seven.

How can I set a condition in a dimension?

I've tried as you can see

but I display an error

Could anyone help me?

Thanks to all!

[joseph_morales]

Hi @danimarc12 ,

You can try this:

Aggr(

      if( conditions, cliente_c)

,cliente_c)

[vinieme12 · Accepted solution]

Add a calculated dimension as below

=   AGGR(    if(  ExpressionForSaldoPre>0 and ExpressionForSaldoPeriodo > 0 , Clienti)    ,   Clienti  )

uncheck show null values for this dimension