How to make compressible table in Looker from visualisation?

So I want to make a visualization in looker where i can expand and compress the table similar to what we can do in Looker Studio. I know on Drill but i don't want to use it as it opens up a different window for the visualisation but i want the expanding of the table inplace only. Please guide me if there is a way we can achieve this.
Thanks 

Solved Solved
0 5 739
1 ACCEPTED SOLUTION

Hi!

I think what you are looking for is using a subtotal table in Looker, here is the documentation

You can also set the subtotals to default to collapsed in the Edit->Series menu 

Here's an example, where I've set country to collapse by default then clicked on "United Kingdom" to expand it:

looker_ant_0-1723128817326.png

 

View solution in original post

5 REPLIES 5