Add column "Perecent of total"

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!

Common Use Cases

Accepted answers

rahuls

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.

Alteryx_Example.yxmd

All comments

rahuls

The file attached will help you build the workflow.

Alteryx_Example.yxmd

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

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.

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

jainn

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703