I have a dashboard with 2 sheets, each having an independent data source.
I want to be able to filter Details sheet based on value selected in Customer Sheet when there is a matching value. In case there is no matching value in Details Sheet corresponding to he value selected in Customer sheet, then then there will will be a Test/Sheet displaying "No matching values".
I am able to filter the values but not siure how to compare values different data sources. Can we display the text/warning sheet by comparing the values?
Any help/idea is highly appreciated. Attached is the dashboard for reference.