Add column "Perecent of total"

[egor_gazarov]

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!

[rahuls · Accepted 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. :)

[egor_gazarov]

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 :)

[MarqueeCrew]

You can edit the file using notepad. Change 10.5 in the header to 10.0.

Sent from my iPhone

[Nikunjpasari15]

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.

[BenMoss]

There are probably a few ways, but it would help if you could tell us why the solution in this post doesnt work for you?

Ben

[Nikunjpasari15]

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.

[JoeBeatty24]

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