Pivot table similar to Excel?

[RitaB]

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!

[LordNeilLord · Accepted solution]

Hey @RitaB 

How about this?

[RitaB]

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

[GiuseppeC · Accepted solution]

Hi @RitaB,

This should give you what you need!

Hope this helps!

Giuseppe

[Thableaus · Accepted solution]

Hi @RitaB 

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

Example attached.

Cheers,

[RitaB]

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