I could use some help on this if I have any takers. Kind of new to Pivot tables and Charts. I have a 7000 row dataset that will be put into a Pivot Table. I am having an issue extracting a Distinct count of Technologist from the data. Working in Excel 2010, this is a sample pic of my dataset.
DS1.PNG
One compounding issue is that we have VUMC Staff and Contract Staff. I set a named range to determine if the listing is VUMC Staff (True) or (False) being Contract staff. I am really only interested in the VUMC numbers. So, Let us say we have 50 cases in a month, each covered by an individual. The same person will do a number of them and someone else will do another portion. So lets say we have 5 Distinct count of Technologist. We can then do an average case per Tech by taking 50/5 = 10 Average cases per Tech. I would then like to have the option to take these Averages and plot them on a chart with some other data.
Here is some of the data in a Pivot Table, Last 2 columns are kind of what I had in mind. I was hoping to get all of this to where I can chart it and filter through with slicers.
PT1.PNG
Thanks for your consideration and help,
Patrick
Bookmarks