newbie-sub total calculation

[beagle]

I have set up a table that contains

catergory

Value

Month

In browse mode I would like to have a subtotal calculation that sub totals all "value" for a given month, without subtotalling for all months. Could someone pelase give me the calculation or do i need to set up more tables?

[Fenton]

There are several ways. It depends how/when you want to see this. If printed, then a Summary field (Total of Value) in a Subsummary part, viewable in Preview mode, after a Sort by Month.

If viewed in Browse mode, anywhere and always valid, then create a Sum() calculation based on a self-relationship on the Month. Be aware that a "month" must also include the year to be unique. A good way to do this, that works well for sorting, is a calculation, result Number (or Text), =

Year ( date ) & Right ( "0" & Month ( date ); 2)

The padding is needed. Create a self-relationship on the above calculation. Then create a calculation, =

Sum ( self_month relationship::Value )

[CobaltSky]

Another option, if your record sets will not be too large, is to use custom functions to break out the sub-summary totals for the found set in Browse mode.

FWIW, an example of this is at http://www.nightwing.com.au/FileMaker/demos8/demo803.html

[beagle]

thank you Fenton..it took a while for me to figure it out but i got there. Your solution worked perfectly.

[Søren Dyhr]

Just be aware of the scaling issues raised by Ray!

--sd