Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi,
I created some pivot tables that show me the number of occurences grouped by some parameters in absolute terms. However, I'd like to get the result as a percentage not of row or column total, but of grand total (so both). Example from Excel Pivot table, where this is possible:
The percentages over both the columns and rows sum up to 100 %.
How do I do this in Alteryx?
Solved! Go to Solution.
HI @UnknownUser!
I'm not sure what your source data looks like, but it sounds like you will need to create the % of total calculation (in this example, I used the Summarize, Append and Formula tools) and then Cross Tab the data to put the rows and columns into the right place.
Try this out and see if it works for you!
