Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Pivot table similar to Excel?

RitaB
7 - Meteor

I've been playing with the summarize, cross tab, transpose, and arrange tools, and I still can't figure out how to do a simple two dimensional pivot table. Attached is what I would do in Excel - how do I replicate this in Alteryx?  Basically, I want to know how many of each code I have by date.  I want to create a table with dates in the column field, codes in the row field, and a count of each code in the data field.  Thank you!

5 REPLIES 5
LordNeilLord
15 - Aurora

Hey @RitaB 

 

How about this?

 

Capture.PNG

RitaB
7 - Meteor

Thank you! - is there a way to hide the [Null] in the empty fields to make it look cleaner for the end user?

GiuseppeC
Alteryx
Alteryx

Hi @RitaB,

 

This should give you what you need!

 

clipboard_image_0.png

 

Hope this helps!

Giuseppe

Thableaus
17 - Castor
17 - Castor

Hi @RitaB 

 

You could use the Cross-Tab Tool with the Count option.

 

crsotab.PNG

 

 

Example attached.

 

Cheers,

RitaB
7 - Meteor

Thank you @GiuseppeC , @Thableaus and @LordNeilLord for your quick responses!

Labels