Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Grouping and Multi sheet Reporting (with joining of different tables)

EricaMN
5 - Atom

Hi there,

I am having some trouble with outputting reports. I am experiencing two different issues:

 

I have reports which I need to group by departments but also have multiple sheets which show tables by level.

I am able to get my tables grouped into separate workbooks by department but am not able to get the levels to appear on different sheets.

I have two different workflows where I’ve attempted this:

  1.  below where I separated out the tables by the level and then tried to join and output into multiplesheets

 

EricaMN_0-1632836260595.png

 

 

  1. where I have kept all levels into the tables and am again only finding success in grouping outputs by department, but not creating separate sheets for level.

 

 

 

I am having a similar-ish issue where I can output reports grouping workbooks by department  based on level and when I join with similar reports to the above it will only join the one sheet but no more. Example attached. Sheet 3 is the layout of the table pictured in the workflow.

 

Thank you, any help appreciated!

 

 

 

 

0 REPLIES 0
Labels
Top Solution Authors