Why is the Report function not picking up data from one of the source sheets?
I'm currently using the Reporting function to create a Programme Risk Log for two projects (Project Sample A1 and Project Sample A2), each of which is using the same template Risk Log.
As you will see from the screenshots, both Risk Logs are selected in the Sheets tab for the Report in question, however only data for Project A1 is being picked up.
I have confirmed that there is data in Project A2 and that the sheet has been saved. I have also tried refreshing the report, but the issue remains.
The templates for both projects are identical, so can anyone tell me what I'm doing wrong?
Many thanks and I look forward to hearing from you!