You can Rename the Customer to Customer Name and Create Join and use that to filter both Sheets on Dashboard by applying to all sheets on Dashboard.
1 of 1 people found this helpful
I used Superstore data and Joined Orders and People Sheets from same excel workbook.
I got Region Column From both the sheets
Select Region and Region People from the Add Fields
Check the below link.
If this resolves your issu, do mark as helpful or answered to help others.