Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

Transpose/Crosstabs Help

5 - Atom



I'm still new to Alteryx and I'm attempting to change Figure 1 below to look like Figure 2. I've been trying to work with the Crosstabs or Transpose tools in order to create Figure 2 but I'm either using the tools incorrectly or using the wrong tools altogether. If anyone has some insight, I would appreciate it! Thanks!


Figure 1

2019-07-24 08_42_28-Alteryx Designer x64 - Ancillary Upsell Workflow.yxmd_.png


Figure 2

2019-07-24 08_46_12-Book1 - Excel.png


Alteryx Certified Partner
Alteryx Certified Partner

Hi @calmeria 


To pivot the Column names you can use the Cross-Tab Tool.

Group by BuyUpDate, use BuyUpType as Column Names and Count as Value.


You can also drag a Summarize tool and calculate the total separately, grouping by BuyUpDate (parallel yo your Cross-Tab tool, not after). 

Then, use the Join tool to append the Total column to your pivoted table, using BuyUpDate as the linking field.



5 - Atom



It worked! Thank you!