Percent of total - Values

[JDong]

Hi Team,

I need to calculate the percentage value for 2 columns

Closed	Open	Closed %	Won %
0	1
0	1
0	1
0	0
0	0
1	1
0	1
0	1
1	0
1	0

How can I get the results for Closed% and Won% in the above table ? 

Thanks

[atcodedog05]

Hi @JDong 

Can you provide an expected output for this sample data.

[atcodedog05 · Accepted solution]

Hi @JDong 

Is this what you are looking for?

Here is a workflow for the task. If not provide an expected output i can help out🙂

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[JDong]

@atcodedog05 

Sure. Please refer to the below grid

Fruits	Closed	Open	%
Grapes	0	1
Grapes	1	1
Grapes	0	1
Grapes	0	1

So here I select fruits and the % calculation should be now based only on the Grapes category.

Thanks

[Emil_Kos]

Hi @JDong,

In order to do so you need to modify the summary tool in the workflow. I would suggest reading about summary tool to understand it better:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Field-Summary/ta-p/104...

The workflow:

The output:

Good Luck!

[atcodedog05]

Hi @JDong 

Just before you posted expected output. I posted a reply similar to your excepted post 😅

[JDong]

Thanks very much to all....it works great !

[atcodedog05]

Happy to help 🙂 @JDong 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂