Filter 3 latest date

[Chunbin]

Hi 

I am currently having an issue of filter the data in alteryx. In the table below I want in each title only select the 3 lastest media plan month.

Wondering how can I do that?

Thanks

[jdunkerley79 · Accepted solution]

Use a Sort tool to order by Title, Media plan month

Then use a Select tool grouped by Title and select just Last 3

Sample attached

[Chunbin · Accepted solution]

That works!  Thank you very much!