Excel report and Alteryx capabilities

Question

Hi, I am new to Alteryx and have specific questions about its reporting capabilities.

I am curious whether Alteryx is a feasible option to automate the Excel reports that I generate today. Can the following of the excel features be retained in Alteryx excel output?

* Excel report has an Index page (see attachment) with a link to each sheet in the excel workbook. Users clicks on the link in the index to see the target excel sheet .
* Excel report has sheet has pivot table with pivot filters (see attachment).
* The filter selected on one sheet also filters the pivot in other sheets in the excel workbook.

If the feature can not be retained in the Alteryx output as excel, can it be done in any other report output format?

Thank you!

Index.PNG

Filter in Excel Report.PNG

dougperez · Accepted Answer

I think you will need a dashboard program (like tableau or powerbi) to do these features (alteryx can do some of those like:https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-pivot-table-with-filters-like-Excel/td-p/299592#:~:text=Open%20the%20newly%20created%20Excel,when%20opening%20the%20file%E2%80%9D%20button)
But I recommend an use of a dashboard program, you can use tableau output to populate tableau dashboards, or just populate some tables on your database and plug these programs on.
If this answer helped you, mark as solution!