This content has been marked as final. Show 2 replies
Is there way to create one filter for different sheets in dashboard. I have two sheets in the dashboard. 1st sheet have 'product' info and 2nd sheet have 'type' info. Ideally i would like to have one filter based on 'Product'
For example If product is Apple, then 2nd sheet should automatically show all products that have same type as a filter(Apple,Orange, Banana and Kiwi). Show only relevant field does not work because when product field changed, Type needs to be selected