community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Pivot table: display as grand total

Meteor

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:

 

Capture.PNG

 

The percentages over both the columns and rows sum up to 100 %.

 

How do I do this in Alteryx? 

Highlighted
Quasar

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.

 

Capture.PNG

 

Try this out and see if it works for you!

Labels