Alteryx Designer Desktop Discussions

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

How to write cumulative percentage

LeiCheng
8 - Asteroid

Anybody knows that if Alteryx can do the cumulative percentage calculation? Many thanks.

My raw dataMy raw data2.jpgthe Expected resultthe Expected result

 
 
 
2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

Hey LeiChang. I would say this is a percentage calculation at different levels of aggregation, not really a cumulative percentage. However, I got the same numbers as you wanted. See if the attached workflow gives you some ideas on how to do it!

 

Screenshot (14).png

LeiCheng
8 - Asteroid

Hi , @PhyilipMannering , You are genius! THANKS.

Labels