How to add Expand and Collapse in table visual

[Anonymous]

Hi guys,

I created a custom hierarchy in my Product table, it;s a group and product number only.

If I put this on Table, I expected to have those kind of Group first then we can expand it to see the Product inside (the usual + and - icon), does it normal (possible) or it have to use Matrix visual ?

Currently it is just a plain Group and number, no grouping or categorizing.

Thanks

[Fowmy · Accepted solution]

@Anonymous 

This feature is available only in Matrix visual. You need to change your Table visual to Matrix. There, you can just stack the dimensions fields without having to create a hierarchy.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Anonymous]

Hi @Fowmy 

But actually what "bad" of matrix is (or I don;t how to do it), for instance what I need to expand and collapse is only that Group, then there is other information that I still want it just like table did.

Something like this:

If change to matrix, this info like Warehouse, location will be under the product.

I can put as Stepped Layout to Off, but then everything will be pull, and if I didn't expand my Product number (as the 2nd column), the 3rd column which is Warehouse will not shown.

Or can we make some Row component always expand? so I will put my Poduct number to always expand, but Group not, so I expand and collapse group, and when expand Group, all is shown.

Thanks

[Anonymous]

Hi,

ok thanks, thought it works in Table as well. 😁

rgds,