Straight table show only dimension with values - hide

[#1]

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!

[tresesco]

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).

[swuehl · Accepted solution]

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

for your second expression:

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

for your third expression:

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

Then check 'Suppress zero values' on presentation tab.

[#4]

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

=if(Sum({<Date_Clean={'$(vDynamicDateUser)'}>} AntalBuy) >=1,Sum({<Date_Clean={'$(vDynamicDateUser)'}, EventTypeKey={196}>}AntalBesøg),null())

would this work proper?

[Clever_Anjos]

Both @tresesco and @swuehl

[tresesco]

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.

[pranubitla]

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