Categories and Subcategories count together

[domeckn]

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?

[Kenda · Accepted solution]

Hey @domeckn 

The attached workflow shows how I would approach this problem. First I created a column that is either 1 or 0 based on which count group that row belongs to. Then I used two different Summarize tools to group that data up then finally a Join to bring it back together. 

Hope this helps!

[Raj_Singh1]

hi @domeckn 

please see attached excel for input and worklow.

it solves your solution. please let me know if its an acceptable solution. if you have any questions or need more changes then let me know.

thanks 🙂