How to create a global filter which should change the filters on other page based on condition.

[Anonymous]

Hi All,

I have a requirement where I have to create a Global filter which is a combination of Sector, Product, Team and Sub-Product. 

Sector, Product, Team and Sub-Product are my separate tables.

Sector

Sector

CBP

CH

FIG

FSG

GI

INFRA

INT

TECH

Product:

Product

ECM

Advisory

Others

Team;

Team

ECM

M&A

NA

Sector CH

Sector FIG

Sector FSG

Sector GI

Sector INFRA

Sector TECH

SUB Product:

Sub Product

ECM OTHERS

IPO

M&A

OTHERS

PE

QIP

SF

Global Filter which i have to create are:

Global Filter

CH

FIG

GI

INFRA

TECH

M&A

ECM

Now I have multiple report pages, which consist of all these column as filters. Lets say 

Page 1 Consist of Team Filter.

Page 2 Consist of Sector, Team, Product and Sub Product.

Now User want if he select CH from Global Filter, it should change the Team filter to 'Sector CH' in Page 1 and Sector filter to 'CH' in Page 2. Since Page 2 consist of other filters also. It should not filter anything on other filter i.e. ALL should be selected.

Similarly if he select ECM in Global Filter, Page 1 should filter Team to ECM 

and Page 2 should only change Product filter to ECM. It should not change any other filters in page 2.

It is an urgent requirement. Please help and let me know how we can create such filter.

[Greg_Deckler]

Slicers do not normally operate in the way you are describing. You might be able to get there if you create relationships between the tables you are using for your slicers such that the global slicer table ends up filtering the correct rows in the other slicer tables based on the relationships. For example, you could construct your global slicer table like:

Value,   Team Key,   Sector Key,  Product Key,  SubProduct Key

CH,       Sector CH,    CH,    ,    ,

Youl would then relate your "key" columns to the correct table.

[Anonymous]

Thanks for your response. I tried to create the relationship for filtering but apart from filter other slicer, user want to filter it with different values.

For example.

CH is my global filter. 

Columns are my filters.

Rows are my different Report Pages.

If I select "CH" from Global filter. It should select "Sector CH" in Coverage by filter in Action Tracker Report Page.

CH in Sector filter for Closure.

and in Call Report it should not select anything.

Similarly If I select ECM in global filter, the blue highlighted values should filter in different pages.