Tableau: store a dimension across 2 different views

Question

I have two views within one dashboard. In view 1, the user selects one or multiple brandnames from a filter. Each brand belongs to a certain sector, which is also a dimension. What I need is, that the second view only shows those sectors that belong to the selected brands, but in this view the filter of the brand name cannot be used! This is because the second view shows the same measure, but from a higher aggregation level (countrylevel instead of brandlevel).

So I would like to 'store' the associated sector from view 1 separate from the brandname, so that I can re-use it in the second view.

How would I do this?

Answer 1

In your second view you want to pass Brand, which you say is the grain of first view.

So to achieve that you must put Brand in the level of detail of the second sheet.

Then you should create action filter with 1st view as source and second view as target.

Pass Brand as the value from 1st to second.

If you want quick filter, then both the view should be from the same data source. Apply Brand filter to all sheets even if the aggregation level is high it would filter the view.