Summarize by ALL and Region

Hi All,

Is there a way to use one summarize tool to get the Total & % for ALL and a Specific Region Total & % in the Same row? as show in Output?

At the end before the final Output I want to just add four filters to generate Alteryx report for each region to get the desired Output.

Attached the Sample WF and expected Output.

Thanks

Summarize WF.yxmd

Output.PNG

Workflow

Datasets

Reporting

Tips and Tricks

Common Use Cases

Best Practices

Dynamic Processing

Accepted answers

binu_acs

@suby attaching the batch macro

Summarize WF.yxzp

All comments

caltang

You’ll need to calculate the % of total by region first.

You will need a few summarise tools to get it done, I’m on my phone so I can’t build something for you.

The first summarise tool is for you to get the total amount of measure you’re having.

Make a second summarize tool group by region and sum by measure, now use the append tool to append your total calculated to the 2nd summarize tool’s values, then use a formula tool to create a formula expression to get the % by getting values of each region / total * 100 to get the percentage (out of 100).

Once done, you should now have a summarize tool value with each region and their measure and their %.

You can then add a record ID to them, then cross tab the values.

But I guess if you want to try, you can experiment this way!

binu_acs

@suby attaching the batch macro

Summarize WF.yxzp

suby

Thanks for the clarification and I will play around as you suggested.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703