Need Help with hiding a row

[ramyasaiqv]

Hi All,

This might be very basic question but i'm having difficulty in solving the issue so please help me.

The issue is i have a table  box with multiple dimensions, the requirement is  when one of the field has some value (text) it should omit the entire row. Tried using if conditions/ also used straight table so that i can hide the column but no luck.

Header 1

Attached is the sample data and qvw file.

As shown in the table box there are 5 dimensions and  the requirement is when there  is data in the "Clarification" column then it should omit the entire row.

To be more specific for example in the table box  for  PRT# 3834702  "Clarification" column has  "under agreement"  so the entire row should be omitted.

[vardhancse · Accepted solution]

In Dimension,

Create one calculated dimension

=If(IsNull(Clarification),'Null',Null())

Enable: Supress when value is null

[pokassov]

Hello!

Check this please.

Sergey

[Anonymous]

Hi Ramya,

Check the below attachment. Is this your need ?

[ramyasaiqv]

It worked Thank you Sasi.

[ramyasaiqv]

Thank you Sergey appreciate it.

[ramyasaiqv]

Thank you Nivetha.

[vardhancse]

NP.