Need to show row when X present others rows need to hide in straight table

[kishorj1982]

Hi All,

PFA.

When 'X' present in any row I need to show whole that row other rows no need to show.Please suggest

Thanks

[jonathandienst · Accepted solution]

Assuming X is in column 1, then use a condition on each expression like

    If(Column(1) = 'X', <original expression for column2>)

    If(Column(1) = 'X', <original expression for column3>)

    ...

Then ensure that suppress zeros and nulls is enabled

[kishorj1982]

Thanks Jonathan.

Its working