Multiple Row Header Table

Question

I need help in making a multiple row header table here in Alteryx. The output I want is something that can be downloaded into an excel file.

Have tried it using Summary but I am not getting what I want. Can someone help me please?

Attached is the Alteryx file along with my expected output file.

Thank you.

Expected Excel Output.xlsx

Target vs. Achieved.yxmd

allancubos · Answer

Thank you Emil. Will check the workflow you attached. Can't access it now because my Alteryx version is outdated. Would have to update it first,

Emil_Kos · Answer

Hi,

The template is attached.

You will need to remember to output the data using the range.

So keeping this part is important:

$A2:J15

C:\Users\kosemi\Downloads\Expected Excel Output - Copy.xlsx|||Sheet1$A2:J15

Target vs. Achieved.yxzp

Expected Excel Output - Copy.xlsx

allancubos · Answer

Hi Emil,

How can I do a template file with proper columns?

How can I make that output table using the below raw file?

Can you make a workflow that when I run, it would give the result that I want? Have tried Summarize & Crosstab but can't see the result I want.

Raw File: