6 Replies Latest reply on Sep 5, 2014 3:53 PM by philmodjunk

    How to summarize summaries?

    WF7A

      Title

      How to summarize summaries?

      Post

      Hi, all:

      I feel silly--I should know how to do this but just can't remember; I tried looking it up but to no avail. *sigh* Please refer to the attached.

      What I want to do is total the count of a sub-summarized heading. (There are multiple headings for this report but I only included one here.) Here's a breakdown:

      As you can see in the top part of the attachment is the data: 23 records of Content Specialist and 7 records of CS1.

      In the middle is the layout. In the SubSummary section, Count is a Summary field (count) of Indicator__lxn (summarize individually); its name is Count__lxs.

      As you can see, in Preview mode so far so good--the numbers portray their respective counts correctly. But, what I want is a summary of the count so it would show 30 underneath the Count__lxs file (in its own SubSummary section, of course).  I don't want to use Grand Summary since I want to total each heading's totals the same as this heading's.

      TIA for your help!

       

       

       

      Preview.png

        • 1. Re: How to summarize summaries?
          philmodjunk

          Since a Grand Summary would also produce a count of 30, I'm not sure what you mean by:

          I don't want to use Grand Summary since I want to total each heading's totals the same as this heading's.

          Can you provide an example that produces a result that is different from what you would see in a Grand summary?

          • 2. Re: How to summarize summaries?
            WF7A

            Sure thing. Here's the last page--it's where the Trailing Grand Summary plops the total. What I need is for each heading's totals to appear before the following one, so the totals are heading-by-heading.

            • 3. Re: How to summarize summaries?
              philmodjunk

              Assuming that each heading is a sub summary part, you need only put the very same summary field into this sub summary part to get a total of all records grouped with that sub summary part.

              • 4. Re: How to summarize summaries?
                philmodjunk

                More specifically, you can make matching "print above" and "print below" sub summary parts and put the summary field in the "print below" part.

                • 5. Re: How to summarize summaries?
                  WF7A

                  Ah! A light bulb moment.

                  That's what frustrated me: I had tried doing that very same thing (with "Print Above") but FileMaker barked at me saying that I couldn't reuse the same field for a sub summary, i.e., "A Sub-summary part for this field already exists." But, after trying your suggestion using "Print Below", it worked.

                  I'm going to have to find definitive info on the difference since I never encountered that before. Thank you VERY much for your help!

                   

                  • 6. Re: How to summarize summaries?
                    philmodjunk

                    I can't reselect the "best answer" option either, but it's no big deal.

                    The point of the error message is that you already had a sub summary part with those specifications. If you had not tried to add a new sub summary part at all, but just added the summary field to your existing sub summary part, you would have seen the correct total, but located above the group of records as part of the "sub header" instead of below the group as generally will make more sense to the person reading the report.