I've created a single object container with three graphs, so that you can view one of the three at a time. Underneath, I have a Pivot table which should show the jobs that correspond to the graph we are seeing (so it should filter based on which graph is clicked in the container). Can someone help me with that please? Currently, when I switch between the graphs, nothing happens in the pivot table - it just shows all of the jobs. I've attached a screenshot to show what it looks like now.
Thanks for your help!!
Instead of creating three different charts for each type of employee, you should create only one and allow the user to select what type of employee they want to see. This way both objects, the chart and the pivot table, will react to the selection and show only those employees that belong to that type.
Hope it helps!