AnsweredAssumed Answered

Count and Summarize Value Occurrence

Question asked by ntay28 on Aug 6, 2013

Title

Count and Summarize Value Occurrence

Post

     Is there a way to count the number of times each unique value occurs across a set of records?  For example, if I have a set of records that include 3 fields, one being favorite color (see below), how can I count the number of children whose favorite color is each of the various colors?  I also want to group the results by a third field (Classroom in the example) in a sub-summary part in a report.  I've searched for how to do this but I keep finding how to count unique values only, which would  tell me that there were 4 unique colors in the set, but that's not what I need.  Thanks for helping if you can.

      

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
                    

Classroom

               
                    

Name

               
                    

Favorite Color

               
                    

                         Classroom A

               
                    

                         Johnny

               
                    

                         Blue

               
                    

                         Classroom A

               
                    

                         Suzy

               
                    

                         Pink

               
                    

                         Classroom A

               
                    

                         Amy

               
                    

                         Red

               
                    

                         Classroom A

               
                    

                         Joe

               
                    

                         Blue

               
                    

                         Classroom A

               
                    

                         Fred

               
                    

                         Red

               
                    

                         Classroom A

               
                    

                         Joseph

               
                    

                         Blue

               
                    

                         Classroom B

               
                    

                         Frank

               
                    

                         Purple

               
                    

                         Classorom B

               
                    

                         Bill

               
                    

                         Blue

               
                    

                         Classroom B

               
                    

                         Cindy

               
                    

                         Blue

               

      

     Favorite Colors in Classroom A: 

     Blue - 3

     Red - 2

     Pink - 1

      

     Favorite Colors in Classroom B:

     Blue – 2

     Purple - 1

Outcomes