Select location filter and add only relevant values. I've checked report and it correctly filters locations based on regions.
Thank you for your response. I already have that in place. The problem here is when I change the Region filter say for example from SCAL to NCAL, it doesn't automatically update the Relevant Values in the Location drop down.