Hide Column based on Expression

[#1]

Hi,

I have a table as below with record type as dimension.. I need to hide the rows which have no issue and display only the once with the issue. How can I achieve this.

Thanks in advance

[vishsaggi]

IS this a Straight table ? If yes,

In the Expression tab:

Check Enable conditional for that specific Column name (Issue)

Then write = Only(Issue) = 'No Issue'

Try this.

[#3]

I tired it. The expression says " Bad Field Name(s): Issue.. Its not working..

[#4]

and it s a straight table..

[ecolomer]

You can also, write this expression in the dimension:

=if(Issue <> 'No Issue', [Record Type])

and check option  "Supress when is Null value"

[vishsaggi]

What is the field name for this No Issue value in the table ?

[#7]

It is not a field in the table.. It is an expression defined based on this "=if([DM]-[Oats]<0,'Oats Not in DM', if([DM]-[Oats]>0,'DM Not IN Oats', if([DM]-[Oats]=0,'No Issue')))"..

[vishsaggi]

Can you try this?

Edit the expression for Issue Calculated column as below:

=if(DM - Oats < 0,'Oats Not in DM',

if(DM - Oats > 0,'DM Not IN Oats',

if(DM - Oats = 0, DUAL('No Issue', 0)

)))

-> Go to Presentation tab and Check Supress Zero values.

[#9]

I tired it but it doesn't work either.. I tired it from the script side and pulled up only differences and populated the chart.

[vishsaggi]

Right, I need you to send me your sample app with scrambled data if any confidential information. I have populated based on the image you have sent and it worked fine at my end. Can you populate some sample data and send it pls ?