Double Headers - Dynamic Month Header and two calculation columns for each month
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
