Prioritization Using "Group" in Summarize Tool

Hi,

Does prioritization work in Summarize tool? I have 4 parameters to consider to sum a value; I tried this order - "group by" A, B, D, "max" C, "sum" value. I thought it worked fine but when I used the same logic to thousands of data, apparently "max" C is not considered. The values end up getting summed as long as A, B, D are satisfied.

same	same	different	same		sumif
A	B	C	D	Value	Expectation
aa	bb	cc	dddd	10	10
a	bb	cc	d	10	10
aaa	b	c	d	10	10
aa	bb	ccc	dd	10	20
aa	bb	cc	dd	10	20
aaa	bbb	cc	ddd	10	20
aaa	bbb	ccc	ddd	10	20
aa	bb	cc	ddd	10	10

Appreciate your help.

Thank you.

Developer

Tips and Tricks

Best Practices

Accepted answers

grossal

HI @crazybeauti_ful,

I think the problem is, that the summarize tool will only sum it up when the value in c is max. Here is a little workaround.

Workflow attached. Let me know if this is what you are looking for.

Best

Alex

2020-03-30-max-c.yxmd

All comments

T_Willins

Hi @crazybeauti_ful,

You are correct in that Max C is not considered as it is not a grouping or a filter, but returning the highest value that meets the criteria above it. All the amounts in the Value field are still there after the Group Bys. What you want to do is filter by the Max C after the Group By A, B, and D. If you use the same Summarize tool but do not include Sum Value it will give you the filter as an output. Joining this back to the original data gives you effectively a filter on the J output.

Group By Summarize.png

Group By Summarize.yxmd

crazybeauti_ful

Thanks, @T_Willins however, I don't get the sum results that I need for those with 20 in the 'expectation' column 😞

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703