Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Add a calculated dimension as below
= AGGR( if( ExpressionForSaldoPre>0 and ExpressionForSaldoPeriodo > 0 , Clienti) , Clienti )
uncheck show null values for this dimension
Hi @danimarc12 ,
You can try this:
Aggr(
if( conditions, cliente_c)
,cliente_c)
Add a calculated dimension as below
= AGGR( if( ExpressionForSaldoPre>0 and ExpressionForSaldoPeriodo > 0 , Clienti) , Clienti )
uncheck show null values for this dimension