Prioritization Using "Group" in Summarize Tool

[crazybeauti_ful]

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.

[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.

[crazybeauti_ful]

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

[grossal · Accepted solution]

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

[crazybeauti_ful]

@grossal thank you so much!!