I have taken Column A and Column B in the filter. When i am changing Column A the corresponding data is not coming under Column B.
Column A data is coming from 1 data source and Column B data is coming from another data source and there is one primary key available in both the sheets. I have linked it with Primary key but still in drop down its not taking the relevant data.
help me on this.
Hi Ratan -
Sorry, relevant value functionality only works within the same data source - not cross-data source as you're attempting.