-
1. Re: Applying the same filter on other worksheets
Zhouyi ZhangFeb 28, 2018 3:11 AM (in response to siying.tan.3)
Hi, Siying
Change the table calculation of percentage to LOD as shown below
{Fixed [Customer]:sum([Revenue])}
/
{Fixed :sum([Revenue])}
And then filter your view with this calculation so that it could be applied to 2nd worksheet.
ZZ
-
2. Re: Applying the same filter on other worksheets
siying.tan.3 Mar 1, 2018 12:30 AM (in response to Zhouyi Zhang)Hi ZZ,
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.
Thanks.
-
3. Re: Applying the same filter on other worksheets
Zhouyi ZhangMar 1, 2018 2:51 AM (in response to siying.tan.3)
Hi, Siying
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
ZZ