Forum Discussion
Relationship for filter data from multiple tables
Hi x0 ,
The first thing I would suggest is that you are joining the four tables using custom date and then using summarize to generate a dimension table containing leasing agent , Property , custom date.
For slicer, you can use for example var _Property = selectvalue('dimtable' Property),to get the value of slice and then match it with the data in the table, depending on the actual requirement.
This may not be the easiest way to do it, I hope it helps and good luck with everything.
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly
Hello Anonymous
can you explain me the way to configure this setup as you suggested ?
do i need to create Column or table or you mean to say i will apply on existing table custom table ?
please give me more detail for solution