Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Double Headers - Dynamic Month Header and two calculation columns for each month

ewibby11
6 - Meteoroid

I am trying to recreate an Excel report that is normally manually created with a copy and paste. The top row is the month which needs to update every run (on a monthly basis). The next row is the normal column headers that include a group ID column and two repetitive column headers. I attached an example of what I am trying to recreate for better visualization. Is this a possibility? 

 

en1900_1-1686322871451.png

 

 

3 REPLIES 3
geraldo
13 - Pulsar

@ewibby11 

 


Could you give more information:
About where the header of the months will be generated
Total ARx and Magim are the same for all months, could you explain why for merging columns I will need more information

Erin
10 - Fireball

You might be able to accomplish this with some Reporting tools. This article helped me a lot when creating similar request: https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/ba-p/9787... 

ewibby11
6 - Meteoroid

The data is getting pulled through a SQL each month. The dates show up as YYYY-MM-DD so some formatting will need to be done. In a perfect world, the month columns would update each month when the data is pulled and the Total ARxs/Margin columns would populate under each month as shown in the example. 

Labels
Top Solution Authors