SOLVED
Pivot table: display as grand total
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
UnknownUser
7 - Meteor
‎01-10-2019
06:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Data Investigation
1 REPLY 1
13 - Pulsar
‎01-10-2019
08:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
