AnsweredAssumed Answered

Trailing Grand Summary Not Working

Question asked by dg3321 on Oct 5, 2010
Latest reply on Oct 5, 2010 by dg3321


Trailing Grand Summary Not Working


I have a report in which I list the rent each tenant pays per property (10 properties total).  The report is sub-summarized by property.  I want to do two things.  First have a trailing total of rent per property (add up all the rents for each property).  And two, i want a grand total of rent collected for the entire 10 properties.

I created a summary field set to get the total of 'rent'.  However, when i inserted the summary field into the layout of the report (so as to add the rent for each property), it would only report the rent listed from the first tenant, as opposed to adding the rent for all tenants per property.

where am i going wrong?

I'm on FMP11 Advanced.