community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.

Sub-headers/Sub-fields in Reporting Tables

Community Content Engineer
Community Content Engineer

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:

 

21.png

 

In Alteryx, with similar formatting:

 

22.png

 

The attached v10.5 workflow goes into the details of the approach, but the essence is below:

 

  1. Split your columns/fields your desired categories (making them sub-headers)
  2. Create tables from your categories, add your supra-headers
  3. Combine the reporting elements we have now, use the Union Tool to stack and the Summarize Tool to combine the reporting elements horizontally
  4. Combine your sub-tables into a larger table, if needed (adding another header)

 

There you have it! Your tables are now rendered in style.