Table from Multiple Datasets
I want to create a table that will pull data from multiple datasets. For example: each dataset has user name and data fields.
1st dataset has: username, date, ticket type, count by type.
2nd dataset has: username, date, inbound calls, outbound calls, productivity.
3rd dataset has: username, date, net collected, potential revenue.
I want to create a dataset that has username, date, count by ticket type, total inbound calls, total outbound calls, total productivity, total net collected, total potential revenue. (So these would be the headers and then each agent would appear once with their total for each column.)
I included a picture of sort of what I want to achieve... (headers are different in this example)