Return the first 5 rows for each repeated name

Seffana_

Hello, 

I have a list of Award names that repeated multiple times. Unfortunately the number of repeats vary for each award name and their corresponding ceremony. 

Does anyone know how to return the first 5 repeated award name for every award name irrespective of how many repeats there are? So, basically I would like to keep the stuff that are highlight in the image and discard the rest. 

Screenshot of results workflow

It most likely is easy, but I have working on the whole workflow the entire and I cannot think of a solution. 

Thank you. 

SAG Awards.yxmd

Thableaus

Hi @Seffana_ 

It's pretty easy using the Tile Tool.

I overcomplicated a little bit to keep things organized and to generate duplicate values, but the key is to use the Tile Tool and then Filter the first five "Tile_Sequence_Num" of Unique Values.

WF Solution appended.

Cheers,

WFSolution.yxmd