I have only two tables to join but I have more than one key needed
I have two tables above. The first table (Errors) has a measure of count(CoachingErrorType) and the second table (Calls) has a measure of SUM(ANS). What I'm trying to do is get an error percentage of the sum(ans) which is the error percentage of total calls eventually Count(CoachingErrorType)/Sum(ANS) and then be able to drill down by site, supervisor, date, and segment. I can join on one key and get the results I need, but I want to be able to drill down by site, supervisor, and segment. How can I do this if I only have one key. I tried joining the tables on multiple columns I tried two at first ( see below) but that didn't give the results I was looking for. I am still getting duplicate supervisor columns, etc.
Errors: LOAD AutoNumber(Supervisor&Segment) as Key, DateCompleted, CallDate, AddedBy, AgentName, [Supervisor] as Errors_Supervisor, Location, CallType, FormType, CoachingDetails, CoachingErrorType, CallInfoType, CreditUnionName, [Segment] as Errors_Segment, CallId FROM [path], table is Errors);
Right Join LOAD AutoNumber(Supervisor&Segment) as Key, "Date", Site, [Supervisor] as [Calls_Supervisor], [Segment] as [Calls_Segment], ANS FROM [path] (ooxml, embedded labels, table is Calls);