Accummulating totals in a summary field with two sub summary elements
Consider the the table TA with TA::PropertyId, TA::Year, TA::Stays. You can have several properties in several years. You will have one record per stay. Now ... I need a summary by property and year. I have also decided to do this at the table level instead of using a layout. The reason being those stats and others are the basis for my reports, but are not the reports themselves.
TA will be sorted by PropertyID and by Year. I can total the stays in TA::AccummulatedStays by property for instance: create a summary field TA::AccummulatedStays; Total it as running with restart when sorted by TA::PropertyID. Works ... now
How do I tell it to break and restart when the year changes ?