Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Pivot Table Query - Summarize? Transpose? Cross Tab

benmillea
7 - Meteor

Hello,

 

I'm trying to replicate an Excel pivot table using Alteryx and I'm struggling to find the best method to get exactly what I need.

 

I've attached a file which shows raw data in the "Data" tab and how I want it to be displayed int he "Display" tab.

 

So I need the 4 possible values from the Outcome_Desc field to be shown as new headers with a sum of each displayed beneath.

 

I've read through quite a few different posts but I can't seem to get to where I need to be and I don't know which tool(s) work best for this.

 

Any advice/solutions would be brilliant

 

Many thanks

 

Ben

Emil_Kos
15 - Aurora

Hi @benmillea,


I have created a workflow for you.

If this was something useful please mark it as a solution!

 

Emil_Kos_0-1614094010044.png

 

The output:

 

Emil_Kos_2-1614094031842.png

 

 

mot
9 - Comet

Hi @benmillea,

 

I have attached the workflow that would get what you need.

Screen Shot 2021-02-23 at 10.27.04 AM.png

I hope it helps. Best!

benmillea
7 - Meteor
That's superb - thanks very much for your help!
benmillea
7 - Meteor

Thank you for this - very useful and much appreciated

benmillea
7 - Meteor

That's superb - thanks very much for your help!

Labels