In dashboard filter, concatenate values to filter between two report
Hi, I have two reports, both linked in the dashboard with the same filter/column. However some of the values in the linked report field does not appear as selectable in the master report linked field. The consequence is then that I cannot choose to filter on values in the linked report which isn't in the master report. The consequence is that when filter some results are missing in the output as they are in the linked report only.
Is it possible to concatenate or control the values of the columns of the two reports such that I can filter on the complete selection of values between the two reports?