Simple counting to create a table

[Bernard455]

HELP! I just got Filemaker Pro 7 and have what I'm sure is a VERY simple question (but I'm not getting it!). I have data for a photograph print competition that I want to get statistics on. There are different categories the prints can be entered in, and in each category the print can be given a blue, red, white or green ribon.

What I'd like to be able to do is calculate 1)the total number of prints in the competition, 2) the total number of prints in each category, 3)the total number of blue, red, white, and green ribbons in each category.

A table with the above information would be great. And if you can tell me how to get the percentages - bonus points!

THANK! (from a newbie!)

[cobra]

Hi Bernard455,

Create a field named Total_Records and define it as a count of your record ID field. Leave "Running Total" unchecked in the Define Summary dialog.

Create two fields as follows:

Percent_Category =

GetSummary(Total_Records; Category) / Total_Records

Percent_Ribbons =

GetSummary(Total_Records; Ribbon) /Total_Records

Create a new layout with 2 sub-summary parts. One will be a sub-summary when sorted by category and the other a sub-summary when sorted by ribbon.

The sub-summary part sorted by category will have the following fields:

Category, Total_Records, Percent_Category

The other sub-summary part will have:

Ribbon, Total_records, Percent_Ribbon.

Sort your records by category and ribbon. View your new layout in preview mode.

Hope this helps,

Cobra

[Bernard455]

THANK YOU Cobra! Much closer to what I'm looking for. I appreciate your help. Is there a way to make it look something like this:

Totals

Category: Total Blue Red White

Portrait 10 3 5 2

Commercial 15 5 4 6

Wedding 8 2 2 4

--------------------------------------------

Totals 33 10 11 12

A similar table for the percentages would put me over the top!

I'm getting it (slowly) - just adjusting to the language structure needed is kind of tough.

Again, thanks so much for your help!