Free Trial

Alteryx Designer Desktop Discussions

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

Calculating respective share

Suvasini
7 - Meteor

Hi,

A very simple doubt. I need to take out the share category wise. So I need to take out total of values (100) and divide a particular category's total/ by the sum total so 50/100 in category A. Kindly help.

CategoryValue
A50
B30
C20
2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @Suvasini,


I have prepared a workflow:

Emil_Kos_0-1617091889690.png

The output:

 

Emil_Kos_1-1617091907086.png

 

 

afv2688
16 - Nebula
16 - Nebula

Hello @Suvasini ,

 

Easiest way would be probably this.

 

Regards

Labels
Top Solution Authors