A client of mine is trying to understand how much of each vendors products their salesmen sold in the previous year. I've been attempting to connect reports in PBI & Excel to garner the information, but haven't had any luck. Any suggestions on reports that would tie out or a better way to go about this?