How to get total according to selection

[corey]

In the example file attached i need to be able to do a search and get totals for each of the [sc] fields.

EG.

i want a layout to have each OPTION in field [sc] TOTALLED.

I have SUMMARIES for them but it does not categorize them according to the [sc] field.

in the example file:

aaa--->ts= $8000 add's the total of ALL (aaa) categories.

then i ned the same for [tc] and [ma].

Regards

Corey....

aa.zip

[HOnza]

Corey,

I think you should start by using relationships instead of repeating fields.

Once you will have each value in a separate record in a related file, you can use sc as a relationship key, and the Sum function for summarizing your data.

HOnza