Alteryx Designer Desktop Discussions

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

Add column "Perecent of total"

egor_gazarov
5 - Atom

Dear colleagues,

 

Could you please help me with the following (I believe, pretty basic) question.

 

In Alteryx I have a table like this:

RegionSales
Region A50
Region B50
Region C30
Region D70

 

And I need somehow to make a new column with percentage of total sales. So, basically I need output like this:

RegionSales% of total
Region A5025%
Region B5025%
Region C3015%
Region D7035%

 

How can I make this in Alteryx?

 

Thanks a lot in advance!

8 REPLIES 8
rahuls
9 - Comet

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
5 - Atom

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
20 - Arcturus
20 - Arcturus
You can edit the file using notepad. Change 10.5 in the header to 10.0.

Sent from my iPhone
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Nikunjpasari15
7 - Meteor

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
ACE Emeritus
ACE Emeritus
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
7 - Meteor

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
5 - Atom

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.

BranchTenure 1Tenure 2Tenure 3Tenure 4Tenure 5Tenure 6Tenure 7Tenure 8Job family 1 in tenure 1Job family 1 in tenure 2Job family 1 in tenure 3Job family 1 in tenure 4Job family 1 in tenure 5Job family 1 in tenure 6Job family 1 in tenure 7Job family 1 in tenure 8Job family 2 in tenure 1Job family 2 in tenure 2Job family 2 in tenure 3Job family 2 in tenure 4Job family 2 in tenure 5Job family 2 in tenure 6Job family 2 in tenure 7Job family 2 in tenure 8
1625662571322111213321231
2348782412131131213313333
3748754843113212111123321
4333227713221113321121211
5688857472313323231211132
6613614342121212312313133
7671533683321123113211121
8223773381131333222123111
9327561222332121221312213
jainn
5 - Atom

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?

jainn_0-1664301544945.png

Thanks for your help,

Nupur

Labels