see the attached
the approach uses sets to produce the desired result
create a set as shown
and apply it to the worksheets
then add the dashboard action
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Workbook jd.twbx 21.1 KB
Thanks so much for your quick reply! It works now! just another quick question that how should I set up the actions if I want it to show all values on the Dashboard2 when I clear the selection on Dashboard1? Currently it will show 4 people who attended, however I want 6, no matter this person has attended or not.
I also noticed that when I click Absence Counter bars on the left, it will not show the list of people who didn't attend. Would you please advise?