You can use Pivot.
First convert the counts which are coming up as dimensions to number format and change to measures.
Create a Pivot with all your reasons - Write a calculated field ( FinalCount in my workbook) to identify which count to use for each reason
Workbook attached in 10.5
AgentReport.twbx 47.1 KB
Thank you so much! I was missing the calculated fields. This make a lot more sense now!
You are welcome Jim