Based on your screenshots, you are close but probably have sorts setup to reference the exact field (e.g. CTR) instead of the calculated field that returns a dynamic value based on the parameter selection. I setup the attached workbook using sample data to demonstrate two different techniques that accomplish what you're looking for.
The first tab uses a filter on the 'Top 5?' calculated field to only display results where it returns TRUE (similar to your current setup).
The second tab shows how you can accomplish this without needing the calculated field by using a 'Top' filter on the ID field.
Hope this helps!
ParamTop5DynamicSort.twbx 12.9 KB
Thank you for such a quick response, this is very helpful
I did leave out one thing though - I actually have two parameter involved in this... one that lets you select a dimension, and another that lets you select a measure, so it is almost a cascading parameter ranking sort of situation.
For some reason, the top tab in the filter will let me select a top 5 on the dimension, but not the measure. So I tried your rank formula for the top 5, and it was not successful. The attached PDF walks you through my navigation of the parameters. Any other thoughts?
Thank you again!
Continuted ranking issues.pdf 170.2 KB