4 Replies Latest reply on Sep 25, 2013 10:36 AM by dankweb

    Summary Data



      Summary Data


           I have a member database with 100 records, where each member gets 4 types of clothing (shirt, jacket, etc...), and each clothing has a size (small, medium, etc...) which is particular to that member.

           What is the most efficient way to have an overall count of the total number of each item for each size.

           For example, if there were 15 people that had shirts of size small, 25 people had shirts of size medium, etc...


        • 1. Re: Summary Data

               Set up a table related to members with one record for each item of clothing issued to that member. Create a summary report based on this related table. You can use sorting to group the records by type and size and a summary field placed in a sub summary layout part can provide the count for each such group of records.

          • 2. Re: Summary Data

                 Thanks...for further clarity, I want the layout something like below, but in the standard report, I am not seeing how to do this.



                 Items |   Small    Large

                 Shirt           15         23          

                 Pants        12         9



            • 3. Re: Summary Data

                   What I am suggesting, (You did ask "What is the most efficient way...") would look like this:

                       Small   15
                       Large   23

                       Small    12
                       Large    9

                   Getting this data into two or more columns as shown will be more complex to set up.

              • 4. Re: Summary Data

                     Got it and that will work. I see where I was messed up in how I set up the layout.