Hiding nested rows with no data

[arca123]

Hi!
I am trying to create a matrix visual that has different kind of values and it offers option to expand the used rows. However, I wish that the rows with no data, would not offer option to be expanded. Is there any possibility to do this?

I'm attaching an example of what I'm trying to do.
This is the table I'm using:

Shop	Group	Subgroup	Sales
Shop A	Group A	Subgroup A	50
Shop A	Group A	Subgroup B	44
Shop A	Group A	Subgroup C	68
Shop A	Group B		10
Shop B	Group A	Subgroup A	80
Shop B	Group A	Subgroup B	55
Shop B	Group A	Subgroup C	73
Shop B	Group B		15

And this is the matrix I have created:

My goal is to disable the option to disable the expansion of ''Group B'', because it doesn't have any subgroups.

[arca123]

Hi @JoeBarry Thank you for you reply 🙂
When I filter out blanks, the whole 'Group B' is filtered out too and this changes the total sum. This solution won't work, as I want to still see ''Group B'' and total sum, I just do not want to have the possibility to expand ''Group B''

[JoeBarry]

Hi @arca123 

Highlight the Matrix, go to the Filter Pane on the right and in the Group part filter out Blanks