I have two worksheets with different data sources but they both contain two similar fields like customer_name and customer_id. both represents different concepts. i tried data blending but it couldn't workout, can some please help me how to achieve this goal.
If both data sources are not joined, the only way I know to create a global filter is through data blending. Do you know why your attempt to create the filter didn't work?
You can post a sample workbook if possible.