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