Pivot table: display as grand total

Question

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?

ddiesel · Accepted Answer

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!