'Creating a table in Google Data Studio using a value from a position on a ranked list

I have a dataset of twitter posts, and in the GDS table below, the posts are grouped by the dimension name, and ranked by their sum of retweets.

GDS table of users with the most retweets

I'd like to create a new table featuring all the posts from the name in the row index 0. So it would be dynamic with date range changes.

Is that possible, and if so, can you tell me how to approach this? I've been reading about parameters and functions in calculated fields, but am not that familiar with GDS.

thx



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source