Forum Discussion

arca123's avatar
arca123
Advocate I
3 years ago

Hiding nested rows with no data

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:

ShopGroupSubgroupSales

Shop A

Group ASubgroup A50
Shop AGroup ASubgroup B44
Shop AGroup ASubgroup C68
Shop AGroup B 10
Shop BGroup ASubgroup A80
Shop BGroup ASubgroup B55
Shop BGroup ASubgroup C73
Shop BGroup 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.

2 Replies

  • JoeBarry's avatar
    JoeBarry
    Solution Sage

    Hi arca123 

     

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

  • 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''