Hiding Drill option or removing values from specific Matrix row

[dcrow5378]

Is there a way to hide a specific row from a matrix?

From the image below, I would like to be able to hide/zero out the child rows of Wages for Home Office Department while retaining the rolled up value.  I would like to be able to expand all of the other Parent/Children rows normally.  Any ideas?

[lbendlin · Accepted solution]

You would have to remove that level of detail in your source data.  It will still show as BLANK() though.  Ragged hierarchies are not supported in the matrix visual.

[dcrow5378]

Thanks.  Are there any other visuals that will support this option? 

So basically would need to use a SWITCH (or some other function) in Query Editor?

[lbendlin]

This one supports ragged hierarchies

Warning - it will be very slow with anything above 10K granularity in the levels.  Understandably so as it needs to traverse the whole tree to decide what to show and what to hide.