1 Reply Latest reply on Jun 15, 2016 7:05 AM by koushik bowinipally

    cross data source filter

    CHIN CHUAN GOH

      hi all,

       

      I would like to find out how to do cross data source filter.

       

      Example:

      Sheet 1, Data Source A:

      Fruit               Profit

      Apple                10

      Orange               5

      Strawberry         8

       

      Sheet 2, Data Source B:

      Fruit               Sales

      Apple                5

      Orange              3

      Strawberry         4

       

      So, what I would like to do is when I add both of these sheets into a dashboard, I want to filter the fruits so that both sheets will show only the fruit that I choose from the filter.

       

      I tried using action filter but it still fail.