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!
SOLVED

Transpose/Crosstabs Help

Highlighted
5 - Atom

Hello!

 

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

 

Highlighted
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.

 

Cheers,

Highlighted
5 - Atom

@Thableaus 

 

It worked! Thank you!