Filtering Gender from Reference

I wanted to filter the gender of the employees from different reference table.

I have two tables Personal Details and COVID Vaccination Info. In the “COVID vaccination info” table, I want to filter the gender of those vaccinated employee whose gender column is located in the “Personal Details” table.

I’ll use the data for Chart view. Thank you.

What exactly do you mean by “filter” in this instance?

1 Like

Hi Marc… I just wanted to get the number of Male and Female who got vaccinated.

“COVID vaccination info” table doesn’t contain gender, it is located in the other reference table.

1 Like

Thank you, Marc. The links you shared helped the system works.