Start Free Trial

Alteryx Designer Desktop Discussions

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

Show values as % parent row total

alexandraoance
5 - Atom

Hello,

 

How can I show the values from a column as a % of parent row total? I’m attaching a picture of the result I would need to obtain. 

Many thanks, 

12F43A8D-99BF-4E24-9B6D-BCBFE243931D.png

2 REPLIES 2
gabrielvilella
14 - Magnetar

You can use a combination of Transpose and Cross Tab.

gabrielvilella_0-1647448673200.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @alexandraoance 

 

My take on this provided you have grand total row.

 

atcodedog05_0-1647448980529.png

 

Hope this helps : )

 

Labels
Top Solution Authors