Hidden dimension and calculation

[vivientexier]

	Dimension level 2	Sum ( A & B )	Sum ( C ) /  Sum ( A & B )
Alpha	A	A	Null
Alpha	B	B	Null
Alpha	Null	Null	C

Hi,

How can I hide the third line of my table (where dimension level 2 = null) and keep the result of my expression (Sum(C) / (Sum A & B) in the same time ?

I can make all values of the third line equals to null but the line doesn't not disappear.

In table properties, if I chose to not display null values the line disappear but my calculation ( Sum(C) / Sum(A & B) ) as well.

How can I hide the third line and keep my result ?

[SunilChauhan]

supress Dimension level 2

or

if([Dimension level 2]<>'Null',[Dimension level 2])

then supress null

[vivientexier]

Thank you for your answer.

However, I can't suppress Dimension level 2 because I still need to see A & B.

The if statment change Sum( C ) to null.

An easy way of doing it would be to create two tables but it would be nice to have only one table.

[SunilChauhan]

can you upload a sample file and out put required.