Hello, I have 3 separate sum tools with the data below and I want to stack them for presentation purposes not union them. How can I do that.
3 inputs look like:
Desired Output and format:
There are 2 ways that I do it. You can keep everything as a single combined table and generate blank rows between them based on conditions, or you can split them into separate report tables, union the tables and space between them. If you have a hard time figuring it out then upload a workflow with some dummy data and I will help.
How do you generate blank rows?
Just checking in to see if you were able to adjust the formula and generate the blank rows as needed in your workflow.
how do you want to output/display the data?
you could use a few reporting tools to do what you want. make a table for each dataset and stack them them for reporting. this will still involve a union tool, because that's how alteryx thinks, but you can just union it for the report output and leave them separate in the rest of your workflow if you want. note that this relies on some field indicating which set each one belongs to - you could use a field already in the data, add a dummy field, use record ID or tile, plenty of ways to do that, but for this example i just made the dummy column "Dataset" for it to key off of
