Logic Issue (Added raw data for context)

Hi Folks,   I have 2 fields: Manager Name & Employee Type in which I need to use as criteria for a formula. What I want to do is create a measure or calculated column in a table visual that looks a...