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 trying to replicate an excel summary table showing a row with subtotal for the categories above it. Table 1 is how I currently have the data formatted and Table 2 is how I want it to ultimately look like. How would I achieve adding a subtotal row in alteryx?
There are many ways to tackle this, but I would take the approach of using a "grouping category", Summarize tool, and Union tool set to a specfic output order. Let us know if the attached workflow works for you.
How to add a subtotal row to sum values belonging to specific categories ddiesel.yxmd
Hi @JoRao, you can also cross tab each of your data type (actual, budget, variance), calculate the sum of Printers, Furniture and Paper Total, then transpose them, and finally join them together (as shown below and in the attached workflow).