This is a table calculation field, which means it depends on a certain dimension, in one worksheet, your top 5 is based on category for example, and in the other worksheet, you don't have any dimension with category, in that case, tableau can't generate top 5 as dimension is different.
Hope you understand this restriction.
Thanks so much dude!!! Is there any other way which I can achieve that because its the client requirement.
Thanks in advance!!!
Probably you could use parameter as this is global. But it will depend on your usage in each worksheet.
I even tried with the parameter but unfortunately it is still not working.
the table calculation (Rank and index) that ZZ is referring to is the underlying table for th viz - each viz has one -the filter based on those calculations will only work when the dimension is in each table
now the sets - how did yo create the sets - if they are dependent on a table calculation to do the ranking then you will face the same issue -
Yeah!!! That seems to be right. Thanks for the response dude.