summarizing data

[suzieyoga]

I used to know how to do this…

I need a layout that tells me the total number of each plant on the list.

Fields are: Plant Code, Qty.

Sample data (using commas):

AAAA,15; AAAA,10; BBBB,25; CCCC, 40; AAAA,5; CCCC,10

I want a layout that tells me the total number of each type of plant,  like this:

Plant, Total Qty (from sample data above)

AAAA, 30

BBBB,25

CCCC,50

So,I tried making  Total Qty field, and putting it in a trailing sub summary, sorting by Plant. This doesn't work. I also went through Phil's tutorial but apparently didn't follow directions.

This has got to be Filemaker 101 but I am screwing it up. Where?

[Steve Martino]

This is a basic subsummary report.  You'll want the plant (AAAA, BBBB, etc.) in the sub summary part (Sub-Summary when sorted by) as well as your total field.  Then you want to sort by that part (plant).

Edited December 20, 2017 by Steve Martino

[suzieyoga]

Doing something wrong no doubt.

Image 1 shows how I set up the summary field being the total of Sym Raw.

Image 2  shows the layout (I'm confused about the other fields; shouldn't they be in Body?)

Image 5 shows how Image 2 looks in Browse Mode:

 

Mighty ugly!

[Steve Martino]

In browse mode, are you in List View, not Form View?

Are you sorting on the proper field?

If that doesn't help, can you attach a sample file?

Edited December 21, 2017 by Steve Martino

[suzieyoga]

Steve- of course. Just as soon as I take out the trash and other duties that make the homefront more peaceful

 with Mrs.…probably tomorrow.

Thanks in advance.

 

[suzieyoga]

Progress! I'm going to post this in detail so others trying to figure this out can possibly benefit. It is actually very simple.

Steve requested that I upload a file. No problem except I don't know how to separate this table/layout from the larger file which contains >20,000 records and >130 fields, and many other layouts, so I will be as descriptive as I can.

I am simply wanting a summary of plants by species.

My Total of Qty is a Summary (shown above).

My Layout:

Browse Mode looks like this:

And Preview Mode gives me what I want as well:

So it is exactly what I need, functionally, ready to improve visually. Thanks for the direction, Steve, and thanks, too, to whoever maintains this site, as the way uploads are handled is very sweet.

Any ideas for improvement appreciated!