This content has been marked as final. Show 4 replies
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.