ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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?
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
