Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In Dimension,
Create one calculated dimension
=If(IsNull(Clarification),'Null',Null())
Enable: Supress when value is null
In Dimension,
Create one calculated dimension
=If(IsNull(Clarification),'Null',Null())
Enable: Supress when value is null
Hello!
Check this please.
Sergey
Hi Ramya,
Check the below attachment. Is this your need ?
It worked Thank you Sasi.
Thank you Sergey appreciate it.
Thank you Nivetha.
NP.