I have a survey with data like this
| Employee | Question | Answer |
|---|
| 1 | 1 | 1 |
| 1 | 2 | 1 |
| 1 | 3 | 2 |
| 1 | 4 | 3 |
| 2 | 1 | 1 |
| 2 | 2 | 3 |
| 2 | 3 | 2 |
| 2 | 4 | 4 |
| 3 | 1 | 2 |
| 3 | 2 | 1 |
| 3 | 3 | 1 |
| 3 | 4 | 2 |
| 4 | 1 | 2 |
| 4 | 2 | 1 |
| 4 | 3 | 1 |
| 4 | 4 | 3 |
I have 4 employee, 4 questions with different answers
Chart 1: displays the data for Question 1
Chart 2: Displays the data for Question 2
I want to click on a response on chart 1, get a virtual list all the employee who chose Answer 1, reference the list of employees to filter Questions 2 to see what was these employees Answers for other questions.
Challenge: When I click on an the chart which displays Count(Answer) for Question 1, getcurrentselections & Getfieldselections would capture only Selected Answer. But what I need is the list of employees who selected this answer to reference it else where.
