Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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