It would be very useful if you could simulate what you're trying to achieve by posting a packaged workbook. If you do that, you're more likely to get the help you need.
I've attached a sample. What I want to achieve is that when I click 1002, 1st bar at right hand side will show me 4 (4) and 2nd shows 3 (3) instead 4(1) / 3(1). Thanks!
Filter Action.twbx 30.6 KB