community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Pivot table similar to Excel?

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!

Alteryx Certified Partner

Hey @RitaB 

 

How about this?

 

Capture.PNG

Meteor

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

Alteryx
Alteryx

Hi @RitaB,

 

This should give you what you need!

 

clipboard_image_0.png

 

Hope this helps!

Giuseppe

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @RitaB 

 

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

 

crsotab.PNG

 

 

Example attached.

 

Cheers,

Meteor

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

Labels