Filter a report in lower tab based on the value of a field in WS

Content

Hi,

Following is a scenario of requirement we are trying to achieve. 

We have an object as Project with a self join. 

User will ensure that he adds one specific project (can be considered as a Parent Project, say Project 1 in this case) project to the ‘Related Project’ field on all the five projects/ or four projects excluding the Project 1.

Project	Account	Related Project
Project 1	Account A	Project 1
Project 2	Account B	Project 1
Project 3	Account B	Project 1
Project 4	Account B	Project 1
Project 5	Account A	Project 1

 

·         Project 1 > Related Projects will show Project 2, Project 3, Project 4 and Project 5

·         Project 2 > Related Projects will show Project 1, Project 3, Project 4 and Project 5