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.
Thanks much in advance!
Using hightlight action it is working as expected.