adding the missing information to the summary

Kadi99

if I have the below data and summarized them by region for P1 and financial year 2022, I get the summary as the screenshot. 

How can I add the other regions by default (East, North and South) with amounts 0 in the summary since they are not available for this criteria?

hellyars

@Kadi99 

See attached workflow.  I think this starts to get what you want. 

I created a simple batch macro (using product) that uses a series a of Summary + Join tools to identify and add the missing Regions lines.

I tried to use only stock Alteryx tools. 

I hope this helps.

Top image = batch macro

Bottom image = workflow

AddMissingFieldsExample.yxzp