i have requirement where i need to separate data of the column(ex: product sub category) and show it in two different sheets. After placing these sheets on a dashboard, when i try to highlight one of the product sub category on sheet 1, the sheet 2 is also fading out.
Is it possible to highlight only that particular product sub category in that particular sheet ?
I tried creating a copy of product sub-category_2 and used it as filter in the second sheet, but still it is not working as expected. Please find attached workbook.