Hopefully I can explain what I'm trying to do clearly.

The table I'm working with has records for each student. There is a portal in this layout that lists what number the student ranked each studio. It will always be ranked 1-9. So the portal just contains the field Rank and Studio.

What I need to do is summarize a count of how many people ranked each studio 1,2,3,4,5,6,7,8, or 9.

The other problem is that I want this at the end of a layout. The report above it is a listing of each student and their respective studio rankings.

I attached a picture of how it looks now which is how I want it to look. But I had to create 162 fields just for the totals to work. And I have to change them every year when the studio names change. I figured there's a better way.

Thanks for you help. I've been trying to figure this out for a couple months and haven't gotten anything that wasn't really messy.

The proper way to create reports is using subsummary parts. Here is an article from the filemaker.com KnowledgeBase that will demonstrate the basics of subsummary reporting. Although it was written for earlier versions of FileMaker, it is still applicable to current versions.

http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=5022&p_created=1115172906&p_sid=OHBk2Ybi&p_accessibility=0&p_lva=5022&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MzAmcF9wcm9kcz0wJnBfY2F0cz0mcF9wdj0mcF9jdj0mcF9zZWFyY2hfdHlwZT1hbnN3ZXJzLnNlYXJjaF9ubCZwX3BhZ2U9MSZwX3NlYXJjaF90ZXh0PWNvdW50IHRvdGFs&p_li=&p_topview=1

This type of reporting will eliminate the need for so many fields and will adapt when your data changes.

Edited July 7, 200619 yr by Guest

Thanks for the reply John, but I'm familiar with subsummary reports. Unless I'm missing something really obvious (which is possible), I don't think I can get what I need with a simple subsummary.

As shown in the picture I attached, the a count of the rankings need to be totaled by Studio and Ranking Number, which gives a 9x9 matrix.

I appreciate any help. Thanks.