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
Solved! Go to Solution.
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,