Report - Column Merge

[suby]

Hi All,

• I'm trying to recreate the  atcodedog solution from the below post.

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/ba-p/9787...

when I tried to add a new container in the workflow by adding two two extra columns in the new container.

The city header is not aligned with the new columns APAC & EMEA.

Could you please help where the issue is.

I'm attaching the workflow  as per atcodedog solutions.

[Raj]

@suby 
this is been updated
mark done if solved.

[binuacs]

@suby it works if you change the order in the join tool

[suby]

Hi Raj,

Thanks can you tell us where you made the changes ? I can see you have increased the Fixed size to 7 other than that any other changes you made it to work?

Or is it just you added the to the Join Multiple tool.

Thanks

[suby]

Hi Binuacs,

Thanks say if I want to have the CITY as the Last header not in the Middle how this can be done.

Why this get miss aligned is there a reason for that technically this should work.

Could you please have a look to see how we can get this displayed as a last column rather than in middle.

Also if you have solution please let me know where you made the changes.

In my real scenario  I have the same issue that when we change the order it works.

[suby]

Hi Raj,

I tested it but CITY column should hold only APAC and EMEA.

But in when I opened the PDF and PPT  output I get this form your solution.

Do you know why?

[Raj · Accepted solution]

@suby 
i have added a green container to show how this is done 
once you create such layout for all the groups combine them horizontally using layout tool and you will have a solution.

hope this is clear now.

[Raj]

@suby 
all the Green portion is added and this will work for any format

Mark solutions done if solved.