Hide rows null

[#1]

Hello,

I want to hide NOT TO DELETE rows when value is null in a dimension of my straight table:

I have two dimensions in my table and my expression depend just of one of this dimensions.So, for the dimension product, my expression had a value just for the value "null".

I am using this expression: sum(total <dimension 1> expression) to I have a value for every product.

Because of this, when I remove the value null in a dimension, the value of my expression will be 0 for every product. --> but, I don't want to remove the value, just hide it.

It is possible?

Sorry for my english, my french is better

[#2]

I am not quite sure why you have a dimension against which you are not measuring, but could you use the 'aggr' function in the expression against both dimensions?

Regards,

Gordon

[#3]

It's work. Thank you.

[#4]

But, now I have another problem:

My expression is: aggr(sum(total <Dimension 1> expression), Dimension 1, dimension 2). So, now, the total in my straight table can't be calculate. What I can do?

[johnw]

I'm not sure what you want, but maybe this?

Properties -> Expressions -> Total Mode -> Sum of Rows

[#6]

It isn't work because I have values "null" in my column

[#7]

sum(aggr(sum(total <Dimension 1> expression), Dimension 1, dimension 2)) should work