Create parameter with 2 values All,Top 20 nama it like select.
Create a calculation like this
drag this calculation into Filters shelf in All sheet and select True.
drag the same calculation into Filters shelf in Top 20 sheet and select False.
Dynamic solutions&filters.twb 70.3 KB
1 of 1 people found this helpful
you can achieve Top 20 and ALL options by using sheet selector in dashboard. please check the below link.