Forum Discussion
Calculating Percentage Between 2 tables
Either I'm being really obtuse or I'm completely misunderstanding your scenario. You say location is irrelevant, but then say "I have 2 attendees from Ohio, 2 from Alabama and 2 from Nevada for a total of 6 attendees,".
If you only have one course going on, go with the direct division between the DISTINCTCOUNT of the names attending the course over of the SUM of employees by location.
To be able to help further, please provide sample data to work with.
And, regardless, please read this thread:
Thanks!
I was responding to your comment about locations: "Say Today there have been courses in 5 out of 10 locations, but yesterday there were couses in 10 out of 10 locations." When I say that the location is irrelevant, I mean we don't do courses in actual locations. The location is a piece of metadata about the employee and it will be used as a slicer, just like gender could be used, or job title, or something like that. I thought I provided sample data in the beginning of this thread. I can do that again, but I am not allowed to use dropbox on my computer, so that has always proven difficult for me to attach anything to these forums.
You intitally posted images of your data, with which we cannot work unless we manually type in the values into Excel.
If you have sample, non-confidential data, you can copy and paste it into a post.