This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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.
I just had a quick look at Pauls workflow and fiddled around with the configuration of the 'set specific output order'. With his workflow it appears that when no specific order is given (i.e. it is unchecked), the records get sorted as appropriate, with the sub totals nested in the right place, whereas when the 'set specific output order' is checked, the results get stacked completely at the top or bottom depending on what you have set your output order too.
If this doesnt work you could of course just throw in a sort tool after the union, and sort by the field that you grouped by within your union. In the case of Pauls workflow, this is City.