Displaying value in total, but removing from dimension.

[retko1985]

Hello,

I have a weirdly structure data, where I have a hierarchy structure, and records for higher level has nulls or NA for columns of lower level.

Now I want to create a straight table, where I will show all the values of Level2, and show value of Level1 in a total row, but not between the dimension values.

So I need to get rid of this row marked in red.

I prepared a model example in QVW, attaching.

Can someone help me with this?

Thank you.

[tresesco]

What is your exact expected output?

[HarishG]

Assuming your expected output is just to remove the record NA as shown in screenshot

[stabben23]

Try With this expression

if(Dimensionality()=0,
sum({<Level2 ={'NA'}>}Amount),sum({<Level2 -={'NA'}>}Amount))