The main thing I'm trying to figure out is that I'm trying to count the number of staff members and the number of clients that are in a restraint (see data summary) from the Raw Data. There will be times that a client or a staff member may be in several restraints (in other words, we would count that staff / client once)
Secondary to that it is, for the ambitious (I'll be able to figure it out, but if you want to take a stab at it):
Also, if you are looking at it, could you help me maintain the borders in the pivot tables.
Finally, I want monthly summaries, quarterly summaries, and yearly summaries
Bookmarks