Pivot data and merge cells for header

Andrew_Fischer

Hi there,

I'm having a hard time taking a column (Composite) from my raw data and pivoting it to group by and use as a merged cell column header. This is an example of my raw data set. 

I'd like to use Composite as a merged column header above the AUM, MTD and IndexMTD values so that it looks something like this.

Anyone have any ideas? My input data is attached.

Thanks in advance!

Best,

Andy

Example.yxmd

morr-co

Hello @Andrew_Fischer - unfortunately, I do not believe you can output a file with two headers in the format you have specified. I have attached an example that will get you close, but you would need to manually input the second header. Alternatively, you could check the Show Column Headings option in the first table tool. However, it will render the sub header for every record.

grouped_report.yxmd