Hi Community,
I'm trying to automate a sales report which is currently being sent out manually (emailed).
At the moment the report gets generated in excel and then saved as a PDF (both samples attached).
My question:
- I'm fine formatting the body of the report in alteryx but would like to know if its possible using the reporting tool to dynamically keep the same format for the headers? So for the example below (also attached) the week numbers would change to reflect the current week but the text would remain the same and in the same position within the report.
- Once the above is working I would then like to append the report body so the final result (as PDF) would look like:
Thank you all in advance and please let me know if you need more information.
