Hi,
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.
Hope that makes sense.
Thanks,
Luke
