Forum Discussion
Confusion Over Top N For Distinct Categories
Hi all, I'm in the process of creating a dashboard for my running times, and am looking to create a table that will, upon first load, show my best time for each distinct distance. I then have a ...
Have managed to bodge a solution by making use of a page level filter. Having ranked the times in a new column I referenced this new column in the Page level Filter and set an Advanced Filter to look for #1 only. Not sure if there was a better way of doing it but it'll do for now.
Eric_ZhangMicrosoft Employee
DamienJ wrote:
Have managed to bodge a solution by making use of a page level filter. Having ranked the times in a new column I referenced this new column in the Page level Filter and set an Advanced Filter to look for #1 only. Not sure if there was a better way of doing it but it'll do for now.
Can you provide any sample data and expected output? The descirption in your original post is not quite clear.