Transpose/Crosstabs Help

Question

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

Figure 2

Thableaus · Accepted Answer

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,