6 Replies Latest reply: Nov 18, 2016 12:37 PM by Pranu bitla

# Straight table show only dimension with values - hide

Hello,

I have this chart

How can i make it so it only shows my members where there is a number all the way?

So those with zeros, should not be shown,  it should be like this:

5213731 602,00, 1, 2

only!

• ###### Re: Straight table show only dimension with values - hide

Is your second column a dimension? If so you can check 'Suppress When Value is Null' for that dimension, else for all the expressions, you have to put conditional appearance(presentation tab).

• ###### Re: Straight table show only dimension with values - hide

Column, 2,3,4 are expressions.

Only column one is a dimension.

I did this for column 3

If(column2 >=1, sum(column3), null())

same expressions is here

would this work proper?

• ###### Re: Straight table show only dimension with values - hide

Try this:

calculated dimension : Aggr(If(Sum({<Date_Clean={'\$(vDynamicDateUser)'}>} AntalBuy)>0,YourDimension) ,YourDimension)

Then check 'Suprress When Value is Null' in the dimention tab.

• ###### Re: Straight table show only dimension with values - hide

You can try to zero columns 2 and 3 where column 1 is not a number:

=if(isnum(Column(1), ExpressionColumn2)

=if(isnum(Column(1), ExpressionColumn3)

Then check 'Suppress zero values' on presentation tab.

• ###### Re: Straight table show only dimension with values - hide

Both @tresesco and @swuehl are correct

• ###### Re: Straight table show only dimension with values - hide

Dear Experts,

I have a question, please help. similar to the above example I have 6 dimensions in the list, I would like to hide only null values, from the 6 dimensions see the below screenshot only last 5 rows , if  dimension  A has a null value, Dimension B with a value, that should show.  can you suggest me something