You can create a calculated field that replaces the Site values where the BU Group = BU 2.
This would essentially be a new "Location" field you would use when slicing by BU Group and Location:
Please see the attached workbook. Hope this helps!
Sample-Manny.twbx 11.8 KB
Thanks a lot, Manny! This is exactly what I needed