sumif solution in alteryx

[roige_28]

Hi Guys,

Need help on how to convert this solution in excel to Alteryx please.

=SUMIF(D:D,[@EmployeeID],N:N)

D= employee ID

N = Quality Score

TIA!

[apathetichell]

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Excel%20Us...

particuarly the summarizing data video.

[sergejs_kutkovics · Accepted solution]

@roige_28, use Summarize tool to achieve this.

[roige_28]

thank you! that worked. I figured it's the summarized tool but not sure how to do it.