AnsweredAssumed Answered

Totals in a Summary Layout

Question asked by FilmUser on Mar 11, 2015
Latest reply on Mar 11, 2015 by 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??)

 

Outcomes