Matrix - hide null row headers

[Anonymous]

I have a matrix that has segment, subsegment, and brands.

However, some segments do not have subsegments. For instance,

I need to be able to hide or remove the null header while retaining brand5 and brand6 in Seg B total. I've not been able to find a way to do it nor has any of my coworkers. Is this possible?

Our solution was to effectively make brands 5 & 6 subsegments, but then the formatting ends up being the same as actual subsegments which causes confusion.

Thanks,

Jason

[Anonymous]

That removes all the brands along with it. I need to retain the brands, but clear the null subsegment.

[Ashish_Mathur]

Hi,

Drag a measure to the visual and then follow Amit's suggestion.

[amitchandak]

@Anonymous , Have you tried visual level filter subsegment is not blank?