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?
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
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...
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.
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |