I have two queries that come from universes connected to SAP. I am trying to connect details down to an "Agent Name".
One universe has agent name as NameA: "FirstName LastName" the other NameB:"FirstName.LastName". Unfortunately these wont always match exactly as some profiles include "-" or middle name.
I created an excel table which has the corresponding NameA and Name B as it is given in the queries.
I attempted to Merge NameA in the excel file to NameA in Query 1. and NameB in the Excel file to NameB in Query 2.
I see that if i Make a table with NameA from the Excel file i can attach measures from Query 1 i get the information detailed to that NameA. But, if i add measures from Query 2, i get a Total of the measure NOT associated to NameA
If i change the name to NameB i get the opposite; details to NameB from Query 2, and Total for the Measure from Queary 1.
Looking for suggestions to get the details as per below:
Here is an example of the data.
table on top is an example of the Excel File *then see NameA(Query 1) and NameB from Query 2
I would like to have these show as
But it will either show full Totals for Calls Answered or full Totals for Cases, or both. or 0
something like this