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

Cross Tab / Summarize tool to summarize values in multiple columns

HKR_4410
5 - Atom

I have data like below:

 

HKR_4410_1-1599636376346.png

 

and would like an output like below.

 

HKR_4410_0-1599636328108.png

 

 

 

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

Hi @HKR_4410 I mocked up a workflow that produces the output you describe let me know what you think?

grazitti_sapna
17 - Castor

Hi @HKR_4410 ,

 

This is my take on the problem, I hope it helps.

 

grazitti_sapna_0-1599639087331.png

 

 

 

Sapna Gupta
HKR_4410
5 - Atom

Thanks @JosephSerpis  and @grazitti_sapna  for your prompt reply. Both the solutions worked perfectly...

Labels
Top Solution Authors