I have 2 dashboards one is showing all Top Clients, and other one calculates Ranking Products and Sub products based on a selected client. using LOD and Table Calculations to filter the client.
When passing client from one page to other using "Action Filters" Dashboard not working. Is there any other way?
Hello @krishnapriya Arisetti
I had to fiddle around with this, and I can't tell you all the steps I tool were necessary, but I think I got it to work.
The biggest change: I eliminated you current filter and modified your lookup (kudos to @Deepak Rai who wrote this up in this tread: https://community.tableau.com/s/question/0D54T00000C6B6YSAV/filtering-by-rank )
I added a CALCULATION that sees if the State selected and State (copy) are the same: I did this through a Change Parameter Dashboard Action.
I also changed your rank calc into one with an LOD, but this might not be necessary (experiment-- I did!).
You'll note some of the first states look suspicious (California is 1/1/1, New York is 2/2/2,etc). when you look at their sales, you see these numbers are correct. Go further down the list and you'll see the ranks get jumbled up and are indeed >10.
I hope this what you're looking for?
Michael Hesser, Tableau Forums Ambassador