Hi Team,
I am blending 2 data sources and need global filter work for both data source. But only relevant value option i m not getting for the secondary data source. Is there any way to solve this issue as getting lot of miss placing of data.
I have attached sample workbook with this.
Example : If i select any company name in the sample file place name should change accordingly but its not changing in the filter.
Regards,
3 answers
Are you looking for the drop down to change - like only relevant values?
I know of no way to make that happen - the filtering you are applying is not at the record level in your secondary source - it is at the level in the primary source that has been aggregated to level of the link