I have several regular outputs I use that are in both Excel and PDF (depending on who I am sending them to).
The format of these is always:
For Excel, create a summary sheet and set as the first tab, then create detailed sheets as additional tabs in the same .xlsx file.
The summary sheet always has the same fields, but the fields may reference different detail tabs day to day.
After the output, I can manually open Excel and change the field to a formula that references the other tabs (hyperlink function).
It would be great if I could just type the hyperlink formula in Alteryx and have that embedded into the Excel output.
The same goes for PDFs, except I would reference other pages (or if using PDF portfolio I would reference other PDFs in the same portfolio).
