Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to calculate percentage of a column by row / rows are different in all the column

acaryasin01
8 - Asteroid

 

Hi Guys,

 

I have a data and I need to calculate row by row based on page no.

 

My daya is something like this;

 

Thanks in advance....

 

CompanyPage noConditionCount

 % of Count by Page no

(DESIRED COLUMN)

XYZ CO.2Negative211%
XYZ CO.2Neutral1583%
XYZ CO.2Positive16%
XYZ CO.3Negative17%
XYZ CO.3Neutral1387%
XYZ CO.3Positive17%
XYZ CO.4Neutral2385%
XYZ CO.4Positive415%
XYZ CO.5Neutral571%
XYZ CO.5Positive229%
XYZ CO.6Neutral1789%
XYZ CO.6Positive211%
XYZ CO.7Neutral889%
XYZ CO.7Positive111%
XYZ CO.8Neutral778%
XYZ CO.8Positive222%
ABC CO.3Negative17%
ABC CO.3Neutral1387%
ABC CO.3Positive17%
ABC CO.4Neutral2385%
ABC CO.4Positive415%
ABC CO.5Neutral571%
ABC CO.5Positive229%
ABC CO.6Neutral1789%
ABC CO.6Positive211%
ABC CO.7Neutral889%
ABC CO.7Positive111%
ABC CO.8Neutral778%
ABC CO.8Positive222%
4 REPLIES 4
Luke_C
17 - Castor

Hi @acaryasin01 

 

Here's how you can do this:

 

  • Summarize tool to get totals per page
  • Join to get total back for each record
  • Formula to compute % and format per your requirement

 

Luke_C_0-1632842480128.png

 

 

KarolinaRoza
11 - Bolide

hi @acaryasin01 

 

Attached is my way of solving this.

 

KarolinaRoza_0-1632842594298.png

 

 

 

Karolina

acaryasin01
8 - Asteroid

 

Cool👍👌

 

Thank you so much @Luke_C appriciated.

acaryasin01
8 - Asteroid

 

Thank you @KarolinaRoza Your solution also worked same as above 👍

Labels