Percent Summation

[Scraps822]

Hi Everyone,

In excel I was able to sum a column and represent it by a % in a pivot table. I'm trying to figure ou how to do that with Alteryx.

For instance, 

KPI	Answer	Value
Awareness	1	30
Awareness	0	80
Interest	1	15
Interest		5
Interest	0	10

this is what I have.

I want to get this

73%

KPI	Answer	Value
Awareness	1	27%
Awareness	0
Interest	1	18%
Interest		73%
Interest	0	9%

Any help would be great.

Thank you,

Alberto

[MarqueeCrew · Accepted solution]

You will use 2 SUMMARIZE tools and 1 Join followed by 1 Formula.

Summarize(Answer)

• Groupby KPI
• Groupby Answer
• Sum (Value) - 

Summarize(KPI)

• Groupby KPI
• Sum (Value) - Rename to Sum_by_KPI

JOIN

• Key1 = KPI
• Key2 = KPI

Note:  You can unselect the RIGHT_KPI Field

FORMULA

Percent :=

[Sum_Value] / [Sum_by_KPI]

This should get you going....

Thanks,

Mark

[Scraps822]

Thank you for this! It worked great.