Joined: 24 Oct 2007
Online Status: Offline
Posts: 12
Topic: Show Team Statistics and Percentages Posted: 28 Jan 2008 at 9:26am
I have a Team Report that shows the following:
Any Request that was closed on the same day the request was submitted. Grouped by the Individual who Closed it With a running subtotal next to each name With a Grant Total
So for example
Sally Smith 23 Bob Jones 16 Larry Marks 10 Sam Sparks 31 Jeff Kunk 17 Others 10 Total 107
Now, Sally and Bob are one team and the other employees are on another team.
I now want to show statistics by Team. So in effect what I am looking for is
Team A 39 36% Team B 58 54% Others 10 9% Total 107
This is a Notes Based system so I cannot go to the "server" side and make changes. I tired using Summary and Formula Fileds, but I got lost. I would imagine I would just add to the existing report, but I am not sure how.
I also dont feel like making several subreports any direction?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum