Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can use Field event trigger to pass selection.
It would be better if you provide sample data.
Regards
ASHFAQ
Thanks !!
Thanks,
this would perfectly suit my requirement.