Filter by selecting a value dimension in a table

Looker Q&A Looker Studio
1

Hello

I have a table with 3 dimensions: person, company name and date + 2 metrics: visits and page views.
I would like to let the user to be able to click on a company name in the table and then a chart will display only the data for this company.
So in the page, I have a table with the 3 dimensions and 2 metrics and additionnaly there is a chart that could be filtered out when the user clicks on the company name.

Is there a way to do it ? For now when a user clicks on it, it takes in account the 3 dimensions and I dont want that but only one dimension.

Thanks !

Sophie

2

Hello, please ensure that all your tables and reports are set to ‘cross filtering.’ Once done, you can filter any data you want by clicking on it.

_0-1742442665073.png
_0-1742442665073.png1287×744 39.3 KB

3

Hi thanks for your reply, this is already on in my report. The thing is that if you add a dimension DEVICE for example in your table, how to be able to select by clicking on the table only desktop from this additionnal dimension, because in fact from what I can see it will select the combinaison of the 2 dimensions of the row clicked but this is not the outcome I expect.