Challenge #189: Billboard Top 100

[Metawong]

Spoiler

[James_Driver9]

Spoiler

[powermars]

I know, it's an old challenge. Bear with me, I am new here 🙂

[katiematkin93]

[jon_amanrich]

My solution for challenge 189 hereafter where I used 2 separate ways for top 100 and top 10!

Spoiler

 For top 100 I used a multirow formula: if [Count]=[Row+1:Count] then [Artist]+', '+[Row+1:Artist]
else [Artist]
endif

For top 10 I used 2 summarize tools: The first to group by decade and artist and to count the amount of times an artist appeared each decade and the second to get the max count per decade. 
I then join these tools on decade and count and used a last summarize to concat the artist names. 

[lalaquta]

Good trick for count the items with the most frequence

[fabiohbarboza]

My solution using filters and concatenate from summarize

[fabiohbarboza]

Nice challenge! 

[ahmed1]

My Solution