Subtotal multiple Rows

Hello there,

I am looking to learn how to replicate subtotaling in excel and how I can translate that into an Alteryx Workflow. For each change in store i need to add a subtotal line that calculates different formulas for different sets of data.

So on a new subtotaled line per store break I need a sum of Housholds, an average of income, and other sums and averages. Any guidance would be super helpful, thank you!

Preparation

Accepted answers

PaulT

Greetings,

I threw together a quick sample with some fake data.

Let me know if this helps!

Adding Subtotal Rows.yxmd

All comments

JohnJPS

Could you send it through multiple Summary tools, grouping at the appropriate levels, then join these back to the original dataaset? That will get you the breakdowns. From there it's just formatting.

PaulT

Greetings,

I threw together a quick sample with some fake data.

Let me know if this helps!

Adding Subtotal Rows.yxmd

Sjlosey

Thanks guy! I was apparently way over complicating what i needed to do. The sum tool and union was what I was looking for.

Thanks again!

axn

Hi Paul,

How did you configure your union tool so that the summary tool output didn't just all get unioned to the bottom of the original data? When I try to replicate your workflow, my summarized data just gets tacked on to the bottom of my original data after the union tool.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703