calculation problem

[Optimus]

Hi all, sorry about this but I am still new to using Filemaker, basically I have a table and in that table I have a column which is populated with a series of codes, some of these codes are the same, and what I need to do is calculate how many of each code there are and display these results as a figure on the page.

could anybody help point me in the right direction for doing this??

many thanks

[bcooney]

Sounds like a job for a sub-summary report. What do you mean a "figure on the page?" A total by code type?

[Optimus]

yes so for each code it sohows the code type and a total of how many there are for each.

[bcooney]

Here's a demo. Look for:

- a summary field

- a new layout, a sub summary report. By placing a summary field in a subsummary part, FM calculates individual totals by break field (the field on which the subsummary is based/sorted).

Topic_192506.zip

[Optimus]

thnak you for your help so far : that was extremely helpful :)the result is exactly what I wanted

Is there a way of getting a similar result showing in browse mode??

[bcooney]

yes, sort of.

Topic_192506b.zip

[bcooney]

Oh, and have you seen this? Geoff Coffey's Tutorial about Summaries

[Søren Dyhr]

Is there a way of getting a similar result showing in browse mode??

What measures of data are we talking about here, thousands, tens of thousands or just a handfull?

And why is it important to have the figures in browsemode? You could if the measures are relative small use Ugo's method - see attachment.

--sd

summarize.zip