2 Replies Latest reply on May 14, 2018 10:04 AM by Raghu R

    Create one filter for two sheets

    eric ganbat

      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

       

      TypeProduct
      FruitsApple
      FruitsOrange
      FruitsBanana
      FruitsKiwi
      VegetablePotato
      VegetableCarrot
      VegetableCabbage
      LeafySpinach
      LeafyKale

       

      Thanks,