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.
How can I total and subtotal the following data set? I am looking to subtotal the first set, subtotal the second set and then grand total the two sets, essentially what is already in there but I would like to be able to run it through alteryx as the report I get is all hardcoded.
To do this, you will need to separate your input data into 3 streams to perform each of the summations you require before bringing the data back together.
The first stream will be your data in its current format with the total fields removed, you can then use the summarize tool to get a total sum.
For the other 2 streams, you will need to split your input data. The best way to do this will be to use the Select Records tool (you will require one for each stream) - Select the specific rows you require for each table. Then, as above, if you add a summarize tool to get the sub totals for both.
Finally, you will need to use the Union tool to bring all of your data back together. You will need to give the fields from your summarize tool a similar name, so that you can join these by name within the Union tool.
I hope this helps, but if you get stuck using any of these tools then there is more information available in the examples within Designer. Let me know how you get on.