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

Question

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?

ewibby11 · Answer

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.

Erin · Answer

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/978794

geraldo · Answer

@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