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
Solved! Go to 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 😀👍
Amazing, thanks so much, works perfectly