Hide row in straight table

[engishfaque]

Dear All,

How to hide/remove row from the straight table, such as illustrated in attached screenshot.

Kind regards,

Ishfaque Ahmed

[sunny_talwar]

If SKU is your dimension then you can write something like this:

If(Makeup <> 'Set', SKU)

and then change the Label to SKU

If there is another way you want to hide then use that condition in the dimension.

Best,

S

[sujeetsingh · Accepted solution]

You can use the Calculated dimension as

if(Dimensio<>'Value to be hidden',Dimension,null())

And then supress null for dimension.

[its_anandrjs]

Hi,

Did you try Suppress When Value is NULL option from the chart properties for suppress particular value from the column by selecting that column.

Regards

Anand

[NickHoff]

Suppress When Value is NULL won't work because the value isn't truly NULL with Makeup as 'Set'

[engishfaque]

Dear Anand,

The value is coming correct in Makeup = Set and I'm adding the value of Set in some other expressions.

But here only, I want to hide entire row of Makeup = Set.

I'm not going to disturb any expression where the value of Set is used.

Kind regards,

Ishfaque Ahmed

[engishfaque]

Dear Anand,

Here is my requirement in simple words,

if(Makeup = 'Set', Entire Row Should be hide, SKU)

Kind regards,

Ishfaque Ahmed

[engishfaque]

Dear All,

I'm still facing an issue.

Kind regards,

Ishfaque Ahmed

[sunny_talwar]

Did you try this?

If(Makeup <> 'Set', SKU)

Best,

S

[Anonymous]

In my opinion, sujeetsingh's answer is correct!

=IF(Makeup<>'Set', SKU, null()) and then flag option Suppress When Value is null.

Try it.

Let us know!