I have 2 tables:
Table 1 - Holds all of the data about companies
Table 2 - Holds all of the staff names in my company
Is there a way to create some sort of calculation which shows:
Total Distinct values in 'FieldX' (Table 1) where 'StaffMember' (Table 1) is equal to 'StaffMember' (Table 2)...