Forum Discussion
arca123
3 years agoAdvocate I
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:
| 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.