Only Showing 'Previous Data' if ProjectID Matches

[ericp]

I currently have a scenario where I want to create a report that shows 'current' data as well as the 'previous' data. I have created a report where it shows most of the information, but was wondering how I can create a condition that shows 'previous' data that ONLY matches the correct ProjectID - right now my second data table is showing all 'previous' data instead of just the one that matches the 'current' data. I have provided screenshots of my Report.JS designer file and a previous of what it's generating in Preview.

[ericp]

I figured out a way to set a filter that says show if 'previous' ID matches 'current' ID, but then it'll lock on project 10109, and if I look at Project10110, it will just show me the 'previous' data for 10109 rather than 10110.

[Lech Kulikowski]

Hello,

Please send us your report with test data for analysis.

Thank you.

[ericp]

Please see the attached file

[ericp]

Nevermind - found the solution!

[Lech Kulikowski]

Hello,

Ok. Thank you for the information.