• You could achieve this by having your second tablix as a sub report. You could have a (hidden) parameter in the sub report for say Unit_ID that is passed into the sub report by the main report.

    You can then toggle the visibility of the sub report based on your needs.

    More on sub reports with parameters here

    I hope that helps 🙂


    I'm on LinkedIn