4 Replies Latest reply: Sep 25, 2014 8:19 AM by Venu Gopal RSS

    How to pass filter values across different data sets

    Venu Gopal

      Hi,

       

      I have a Customer Sales data set and a Service request data set.

       

      Both there were totally independent and were used in a dashboard in different sheets.

       

      Now I have a requirement to pass a data field from the Customer Sales sheet to the Service Request sheet. When a user wants to see what was the activity in the Service request for the same date value in the Customer sales, the data should get automatically filtered.

       

      I can create this by having a same column name in both data sheets. But this would be a join between 2 unrelated data sets. I would prefer just passing the value alone.

       

      also apart from the date field, I also have one another common field which needs to be analysed in both the data sets. Serveice Level name.

       

      Can you please let me know how to proceed on this.

       

      Thanks,

      Venu