Change the table calculation of percentage to LOD as shown below
And then filter your view with this calculation so that it could be applied to 2nd worksheet.
Unfortunately, I'm using SSAS data source. So I'm unable to create the same calculation field.
Also, sorry for keeping my example so simple earlier on. My actual dashboard look something like this: Display only the outliers . The final filter was based on multiple other table calculations. I'm not sure what will the corresponding LOD be.
Then you need calculate the % from your cube directly rather than calculate/use table calculation from tableau. Cube is not very flexible data source for tableau