Filter table with a related field of the selected in a dropdown list

[okt]

Hi everyone! 
I have added a drop-down list that contains values ​​from a field called "FieldID". On the other hand, I have a table that contains 2 columns, "FieldID" and "Location". I need that when I select a value or "FieldID" in the drop-down list, it filters the records in the table but that match the same "Location". In support (https://support.google.com/looker-studio/answer/11335992?hl=en&ref_topic=6371413&sjid=61607142526881...) it names a property "Dimension" (in addition to Period Dimension) that would allow me to do this, but it doesn't appear in the dropdown properties for me. Does anyone know how I could get the filter to work the way I want? Thanks a lot!

[lauratilton · Accepted solution]

I think you'd have to use Blending to achieve this. You will be blending your data source on itself using a left join.

Left side of join: FieldID and Location. Rename FieldID as "Select FieldID"
Right side of join: Field ID and Location. Rename FieldID as "Display FieldID"
Left join on Location.

Then, use the blend as a source to create a drop-down list using Select FieldID, and a table that shows Display FieldID (and Location if you want it). 

Then, when you choose Select FieldID, it will show a list of all the Field IDs (Display FieldIDs) at that same Location. 

Blending can get a little confusing but let me know if this works for you! I just tried it on some similar data and it worked for me.

[okt]

It worked perfectlly that way, thanks a lot Laura!!