How to?

[Kathyapaola15]

So I have two columns in excel that I uploaded into Alteryx. The first column shows the IDs and the second column shows years. I want to know how can I know how many times Ex. ID 53 selected "X" year for the second column, and for that to be displayed into Alteryx. 

Thank you.

[JosephSerpis · Accepted solution]

Hi @Kathyapaola15 I mocked up a workflow that I think produces the output you describe. Let me know what you think?

[Kathyapaola15]

Thank you Joseph! It really helped me.