Show 0 instead of skipping lines in Summarize outputs

[45179902]

Right now, the Summarize tool skips records that have count = 0 in its output. I would like 0 to be outputted rather than getting skipped.

Input data:

All the possible combinations are A-A, A-B, A-C, and A-D. Below is an input file.

Type	Category
A	A
A	B
A	B
A	D

When I group by Type and Count categories, I would like the Summarize tool to get me:

Type	Category	Count
A	A	1
A	B	2
A	C	0
A	D	1

Instead of 

Type	Category	Count
A	A	1
A	B	2
A	D	1

If Summarize is not the right tool, other solutions would be acceptable as long as they produce this desired output. Such solutions must not be hardcoded for the given example. It should work for Type B, C, D, etc. as well to be accepted.

[Qiu]

@45179902 
I think we can prepare a list of Type then add the missing "Type" into the output of Summarize tool