4 Replies Latest reply: Sep 25, 2014 8:19 AM by venu Rao RSS

    How to pass filter values across different data sets

    venu Rao



      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.