Return only rows with zero values in table

[Anonymous]

Hello

I would like to have below table but only with the rows for which the column Return Volume is zero.

I have country, year, month, Applicable on Brand, Warranty, Model Type and Marketing offer as dimensions and Return volume etc as expressions.

Kindly advise how I can display this table with only the rows where Return Volume is zero

Many Thanks

Hasnaa

[MayilVahanan · Accepted solution]

Hi

Try like this

Exp1: =if(Exp1 = 0, Exp1)

if(Column(1) =0, Exp2)

if(Column(1) =0, Exp3)

if(Column(1) =0, Exp4)

[Anonymous]

Thanks. it works