Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What is your exact expected output?
Assuming your expected output is just to remove the record NA as shown in screenshot
Try With this expression
if(Dimensionality()=0,
sum({<Level2 ={'NA'}>}Amount),sum({<Level2 -={'NA'}>}Amount))