Creating Row with 0 rather than no data for row when summarized

[hblaiklock]

Hi there,

Is there anyway to force the summarise tool to count 0 when there are no items, rather than not including that row.

I have a dataset of articles that writers have published. Each writer has a unique ID and publishes various different product types throughout the year. Sometimes a writer will not publish a certain product in a month, but I would like to see that as a 0 when summarised.

There are 2000+ writers and 5 product types.

See below for a more detailed example

Current summary output: 

UniqueID	Year	Month	Product	Count
313	2020	1	A	3
313	2020	1	C	4
444	2020	1	A	2
444	2020	1	B	7
444	2020	1	D	4
444	2020	1	E	5

Desired summary output: 

UniqueID	Year	Month	Product	Count
313	2020	1	A	3
313	2020	1	B	0
313	2020	1	C	4
313	2020	1	D	0
313	2020	1	E	0
444	2020	1	A	2
444	2020	1	B	7
444	2020	1	C	0
444	2020	1	D	4
444	2020	1	E	5

Thanks in advance,

Harry

[atcodedog05 · Accepted solution]

Hi @hblaiklock 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[hblaiklock]

Amazing, thanks so much, works perfectly

[atcodedog05]

Happy to help 🙂 @hblaiklock 

Cheers and Happy Analyzing 😀