Hard to follow without seeing the workbook as a twbx file
but in concept parameters are global (apply across the entire book) and static (must be changed by the user) but they don't do anything buy themselves - they need to tie to a filter or to a calculation -
I don't know how you did your top 5 - I prefer to use a rank unique desc and then a filter that equates the rant to a separate parameter set to an integer for the N value
then you are free to create separate ranks on each sheet and use it in a filter on that sheet only as <= to the N parameter
could be more specific with your book
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I made a similar example using Superstore (as not to post company information). So the Dashboard 7 shows the top 5% Customers based off of Profit (worksheet called Top N%(2)). I want to show the only the products in the bottom worksheet (Product Quantity) that these top 5% (31 customers) bought.
Superstore Top N%_v10.5 2.twbx 627.8 KB