How to create table to give pivoted view of the data

disub

I'm looking to achieve table view as per above shared in the image- 1 field to be merged, header fields to be color coded- How this can be achieved?

alexnajm

There are a few articles on the Community to help like this one: https://knowledge.alteryx.com/index/s/article/Sub-headers-Sub-fields-in-Reporting-Tables-1583459852812

here’s some more general direction:

- color in headers? Look at Reporting tools, mainly the table tool

- clearing labels from rows? Look at the Multi Row Formula tool