When we filter in 9 then it will filter whole company data only. it will not filter records. all row will affect while drill in Tableau. Here your row selected based on company.
Thank you for reviewing my work. Is there anyway just to show the effected rows (which only shows the 9 rows affected)?