1 of 1 people found this helpful
It's because you are using a Table Calculation that you do not get the "Apply to Worksheets" option for the filter. Table Calculations are computed within a view, so only apply to that view. If you can create the Alpha as a dimension in your dataset instead, you'll be able to filter across both views easily.
Thanks for the rapid reply.
In that case, if you were to replicate this process, can I please find out what approach will you take?
The original data source doesn't come with an assign Alpha, therefore might make things a little bit tricky.