Create a drop-down from column headers

I'm trying to create a second drop down that encapsulates all of the column headers. I.e., pare down a table by filtering by row, and then filtering by column. Basically, get this table...

Screenshot 2024-04-28 at 9.42.17 PM.png

... down to a 1v1 level. E.g., select "Jack Black" in the drop-down shown, but then also select "Banquet Beer" from a theoretical second drop-down to narrow the table down to just "Jack Black" in the row, and "Banquet Beer" in the column. Like this:

Screenshot 2024-04-28 at 9.44.42 PM.png

As of right now, if I select a Name in the drop-down, it'll just filter the table to one row with all the columns. I just need a way to filter on the column headers in a "Name 2" drop-down. Is this possible? Thank you!

Dashboard view: https://lookerstudio.google.com/u/0/reporting/eaa804c3-0906-4f3f-827f-314a9b0ad5bb/page/p_y4d2ahgy5c

 

0 0 22
0 REPLIES 0
Top Labels in this Space