0 Replies Latest reply on Aug 6, 2013 4:15 AM by ntay28

    Count and Summarize Value Occurrence

    ntay28

      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