Current Scenario is as follows:
I have a parent site where I have a list containing multiple projects with project codes. There can be multiple projects against a project code. The same depicted below in the screenshot:
Here every Project Code will have a specific page(SiteUrl will specify this page). I will have to display data from only those projects specific to each project code. As depicted in the following screenshot:
Note: The second screenshot has values in a calculated column, concatenated columns 'Project Name' and 'Project Code'. The point is I have just added these statically just to share the screenshots. How could I achieve it in real time in SharePoint? That is a list at 'Parent Site', data at all the pages at subsite pages getting updated(filtered according to Project-Code). Thanks in advance.