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.
SOLVED

reporting: additional dynamic header, blank rows, color

Gina2021
9 - Comet

Hello Community!

 

I'm working on my first Alteryx workflow that is expected to be output to excel with a finished look.   I'd like to add 3 additional dynamic header rows onto the raw report, then keep blank rows between the metric names, and finally add some color (doesn't need to be exact shades) to match what I designed the report to look like in excel. 

 

I've run out of project time and could really use some quick hints from the community (.yxmd & excel report attached)

 

Thank you TONS!

Gina

 

Gina2021_0-1619039776835.png

 

Gina2021_1-1619039899906.png

 

 

Gina2021_2-1619039963117.png

 

 

Gina2021_3-1619040020660.png

 

 

Need Alteryx output to look like this:

Gina2021_4-1619040081464.png

 

 

 

 

 

 

 

5 REPLIES 5
apathetichell
20 - Arcturus

Here's  a start...

apathetichell
20 - Arcturus

this looks a bit closer to what you want...

Gina2021
9 - Comet

Thank you so so so much @apathetichell ! I've been working off the tremendous head start you gave me since you posted.  That helped make the entire process less overwhelming.  I just finalized it, and couldn't be happier with the outcome. The workflow is attached in case it's useful to anyone else. Thanks again!

 

Gina2021_0-1619062480504.png

 

apathetichell
20 - Arcturus

Wow!  Great job! That looks awesome!

Gina2021
9 - Comet

Thanks so much!

Labels
Top Solution Authors