Hi,
Looking to show a count of a manager and sub-manager next to each other for a number of categories, I am unable to attach a workflow, so please see the below sample data:
| Inquiry | Manager | Sub-manager | Days to Close |
| 1 | Bill | Nick | 17 |
| 2 | Amy | Jason | 13 |
| 3 | Amy | Jenny | 42 |
| 4 | Roy | Sydney | 24 |
| 5 | Bill | Liz | 29 |
| 6 | Amy | Jason | 19 |
| 7 | Bill | Liz | 34 |
| 8 | Amy | Rick | 53 |
| 9 | Roy | Sydney | 11 |
The output I would be looking for is below:
| Manager | 15-35 Day Count | 36+ Day Count | Sub-manager | 15-35 Day Count | 35+ Day Count |
| Bill | 3 | 0 | Nick | 1 | 0 |
| Bill | 3 | 0 | Liz | 2 | 0 |
| Amy | 1 | 2 | Jason | 1 | 0 |
| Amy | 1 | 2 | Jenny | 0 | 1 |
| Amy | 1 | 2 | Rick | 0 | 1 |
| Roy | 1 | 0 | Sydney | 1 | 0 |
I feel like this shouldn't be as difficult as I am making it, I am trying to do my four counts separately and then do a join multiple, but that keeps getting me a bunch of extra rows. Any ideas?
