Please help with my workflow

[Taxguy03]

Hello experts. I need your help. I'm tasked to figure out a workflow that will produce the name of the country received the most numbers of the award in the "Music" category. The data is in a vertical format. I have attempted to use CrossTab Tool, Filter Too, Summarize Tool but nothing seems work fo me.

The sample data table is attached. Hope you can help. 

[vizAlter]

Hi @Taxguy03 — Could you please review your attached, and provide the relevant sample data or your tried workflow?

[Taxguy03]

I had the wrong file attached. Please see the correct file now. 

[vizAlter · Accepted solution]

@Taxguy03 — Please review the attached solution.

[Taxguy03]

Thank you, vizAlter. I very much appreciated your quick reply. 

The workflow is going to work for me.

Community to my rescue again:-) 

[vizAlter]

@Taxguy03 — Thank you!