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.
If you’ve gotten accustomed to having headers and sub-headers (fields/sub-fields) in your tables, much like those you can build with the “Merge & Center” Excel feature, you’ll be happy to hear with just a couple formatting steps we can build the format below:
In Alteryx, with similar formatting:
The attached v10.5 workflow goes into the details of the approach, but the essence is below:
Split your columns/fields your desired categories (making them sub-headers)
Create tables from your categories, add your supra-headers
Combine the reporting elements we have now, use the Union Tool to stack and the Summarize Tool to combine the reporting elements horizontally
Combine your sub-tables into a larger table, if needed (adding another header)
There you have it! Your tables are now rendered in style.