Hi everyone
In the document attached I need the Pivot on "Sheet 2" to to count the Team members (USI/ECDR) in the "Team 1 (2)" Sheet. From the Pivot I need a pie chart that shows the percentage and absolute value of people in "USI/ECDR". Also the pivot and pie chart should update automatically if new people are added to the list. If possible it should also be possible to filter for active/inactive.
Help would be much appreciated.
Bookmarks