In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
Top Solution Authors