Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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
8 - Asteroid

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
19 - Altair

Here's  a start...

apathetichell
19 - Altair

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

Gina2021
8 - Asteroid

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
19 - Altair

Wow!  Great job! That looks awesome!

Gina2021
8 - Asteroid

Thanks so much!

Labels
Top Solution Authors