Dustin, I think you're looking for something like this for your Actual Admits column:
SUM([Admits]) / (COUNT([Number of Records])/COUNTD([Admin]))
At least it gives the Grand Total you seem to be looking for. (See attached.)
Grand Total Question-SW.twbx.zip 35.3 KB
That does give me the results I'm looking for in this instance! Thanks so much!
But let's throw another wrinkle into it.
What if the user wanted to look just at Sales Teams?
I basically need to develop this for three views.
My Row Shelf would look like this:
View 1: Just Admin
View 2: Just Sales Team
View 3: Like here, Admin and Sales Team.
Is there a formula that could be applied across all three options. It doesn't appear this will work. Maybe adding a parameter could help, but I haven't gotten that far yet, but if you have any ideas, I'd appreciate it.