Very basic data blending dont work - what am I doing wrong?

[Bigdage]

Hello Looker community.

I have a very simple problem (I think).  Let's make it as simple as possible 

1) I have a Google Sheet  with 2 pages (one page per staff).  Each page has 3 columns (Date, Staff name, Sales amount).  

2) I have connected my 2 pages to my Looker Studio .  My challenge is simple:

3) I want to set up a connector where I can select the desired date

4) I want to set up a connector where I can select the desired staff

The problem is when I blend my data using the internal join operator (selecting date and staff for my dimension and sales for metrics) it just returns blank results for my 2 selectors instead of giving me choices

Any idea anyone of what I'm missing here?

Thanks in advance

[momoises19 · Accepted solution]

Effectively, in this case you need to join the data with a union all (vertically), so you can have the filters of both table a and table b, this union all has to be done in the google sheet because looker studio does not allow it.