2 Replies Latest reply on Mar 11, 2015 1:28 PM by FilmUser

    Totals in a Summary Layout

    FilmUser

      Title

      Totals in a Summary Layout

      Post

      Greetings -

      FMP 12, Windows 7 Enterprise

      I am trying to create a Summary report with some total or sum fields and can’t figure out how. I’ve done a few summaries with sub-summaries, but am not really experienced and this has me stumped.

      I already have a script which finds a set of records, sorts appropriately, then goes to a summary layout which works fine for its design – that is the standard “tiered” or “sectioned” sample you see in the layout set up when you choose Report.

       

      Example, in order of sort:

      Size, then color, so it looks like this–

       

      Small               (Count field)

              Green   (Count field)

              Red     (Count field)

              Blue    (Count field)

       

      Medium         (Count field)

              Green    (Count field)

              Red    (Count field)

              Blue    (Count field)

       

      Large               (Count field)

              Green    (Count field)

              Red    (Count field)

              Blue    (Count field)

       

      Grand Total (Count field – all 3 sizes)

       

      If it matters, the color fields are actually calculations, all the same field, and sorted by value of that field, within the Size section, showing a record count on each line. The layout has no body.

       

      I would like to incorporate fields into this report which show the total number of each color, across all sizes. So, 3 fields (sum or total??) on the layout (maybe the same field in definitions placed 3 times??)