Dear colleagues,
Could you please help me with the following (I believe, pretty basic) question.
In Alteryx I have a table like this:
Region | Sales |
Region A | 50 |
Region B | 50 |
Region C | 30 |
Region D | 70 |
And I need somehow to make a new column with percentage of total sales. So, basically I need output like this:
Region | Sales | % of total |
Region A | 50 | 25% |
Region B | 50 | 25% |
Region C | 30 | 15% |
Region D | 70 | 35% |
How can I make this in Alteryx?
Thanks a lot in advance!
Solved! Go to Solution.
To begin with, add a summarize tool to the input whioch will calculate the sum of "Sales". Then append it to the input data using Append Fields tool. Then using the Formula Tool, calculate the percentage of the Sales as another column and finally using Select Tool, remove the Sum of Sales column which was earlier formed using Summarize.
The file attached will help you build the workflow. :)
Thank you so much! Unfortunately file doesn't open on my machine ("This document was created by a more recent version of this application and cannot be read"). But hopefully I understand :)
Hello All,
I have been trying to find another way to add Percentage column field but couldn't find the solution to it.
I would really appreciate if you know if there is alternative way apart from your solution to make a Percentage column field for a give data.
Thanks for your help.
The above solution does work.
There was a sample question that was posted and I wasn't able to find another way to find the Percentage total and add it to an additional column.
I'm trying to get the percent of total across columns instead of rows. The table below is an example of my data. My data set has close to 400 columns. Each column is either the number of individuals in a tenure bucket broken out by job family or number of individuals in a tenure not broken out by job family. The total individuals is equal to the sum of tenure buckets not broken out by job family. I am trying to get to the percentage of total individuals by tenure and job family (column) for each branch (row). Any help would be greatly appreciated.
Branch | Tenure 1 | Tenure 2 | Tenure 3 | Tenure 4 | Tenure 5 | Tenure 6 | Tenure 7 | Tenure 8 | Job family 1 in tenure 1 | Job family 1 in tenure 2 | Job family 1 in tenure 3 | Job family 1 in tenure 4 | Job family 1 in tenure 5 | Job family 1 in tenure 6 | Job family 1 in tenure 7 | Job family 1 in tenure 8 | Job family 2 in tenure 1 | Job family 2 in tenure 2 | Job family 2 in tenure 3 | Job family 2 in tenure 4 | Job family 2 in tenure 5 | Job family 2 in tenure 6 | Job family 2 in tenure 7 | Job family 2 in tenure 8 |
1 | 6 | 2 | 5 | 6 | 6 | 2 | 5 | 7 | 1 | 3 | 2 | 2 | 1 | 1 | 1 | 2 | 1 | 3 | 3 | 2 | 1 | 2 | 3 | 1 |
2 | 3 | 4 | 8 | 7 | 8 | 2 | 4 | 1 | 2 | 1 | 3 | 1 | 1 | 3 | 1 | 2 | 1 | 3 | 3 | 1 | 3 | 3 | 3 | 3 |
3 | 7 | 4 | 8 | 7 | 5 | 4 | 8 | 4 | 3 | 1 | 1 | 3 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 3 | 3 | 2 | 1 |
4 | 3 | 3 | 3 | 2 | 2 | 7 | 7 | 1 | 3 | 2 | 2 | 1 | 1 | 1 | 3 | 3 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 1 |
5 | 6 | 8 | 8 | 8 | 5 | 7 | 4 | 7 | 2 | 3 | 1 | 3 | 3 | 2 | 3 | 2 | 3 | 1 | 2 | 1 | 1 | 1 | 3 | 2 |
6 | 6 | 1 | 3 | 6 | 1 | 4 | 3 | 4 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 3 | 1 | 3 | 3 |
7 | 6 | 7 | 1 | 5 | 3 | 3 | 6 | 8 | 3 | 3 | 2 | 1 | 1 | 2 | 3 | 1 | 1 | 3 | 2 | 1 | 1 | 1 | 2 | 1 |
8 | 2 | 2 | 3 | 7 | 7 | 3 | 3 | 8 | 1 | 1 | 3 | 1 | 3 | 3 | 3 | 2 | 2 | 2 | 1 | 2 | 3 | 1 | 1 | 1 |
9 | 3 | 2 | 7 | 5 | 6 | 1 | 2 | 2 | 2 | 3 | 3 | 2 | 1 | 2 | 1 | 2 | 2 | 1 | 3 | 1 | 2 | 2 | 1 | 3 |
Hi, I'm looking to do percentage of Grand totals in my table. For example, for the first one, should be (4980/41,787)*100. The Grand total of grand total will stay the same in calculating all percentages. Any idea how I can do it?
Thanks for your help,
Nupur