we can filter relevant values. when i filter region-central then it filters central states only. if i select all in region it shows all states.
Your workbook linked with non related sheets, so it grayed. you dashboard 2 shows table view. if you select the any state from the region then it filters the related customer.
please check the filters docs then do it. i have attached the workbook. Dont use action filters with unrelated data that you added before.
state.twbx 473.7 KB
1) 1 have create a report with Market, state columns & Added Quick filters for both columns Market, state.
2) In the Hierarchy wise Market -> State. (Just Information)
3) Click on Arrow symbol of "State", & select related values.