Adding a subtotal in a Layout...

[working.account]

Hello all,

I have a large layout in filemaker that has around 2 million records. I often use this layout to search for particular weeks and items using the find mode. Is there a way I can add something to the laout that would give total for a search?

i.e. If I search for week 20, I would like a total for each feild (total sales, total units) for that one week (or however else I filtered the data.

Thanks for the help!

[aldipalo]

You should be able to do that in a list layout with grouped data. You can show sub totals and grand totals on any number field you wish.

Take a look at the "Sales Report" after searching for a Creation Date Range on the "Sales Rep" layout. This should point you in the right direction.

HTH

Sales_Rep.zip