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.