I'm trying to create a straight table that basically counts the amount of Manual and Automated payments, per Relationship Manager
RM
Manual
Automated
Manual AT
Automated AT
Joe
?
?
?
?
Bill
?
?
?
?
Fred
?
?
?
?
Steve
?
?
?
?
Issue is, the data is brought back in a single field 'Manual/Automated' so I can't do a simple count and am struggling to make it count the number of times each comes up by putting an IF on it. Also, I'm unsure if it will filter down by RM.
