We are looking to create summary reports that allow us to organize volunteering data into meaningful groups with aggregate calculations. In addition, “grand total” type value computed and located at the end of the report.
We have a volunteer database where volunteers can check in and checkout at different locations. Each school would like a report that list the total volunteering hours per volunteer and then the total at the end for each school. The data is stored in two different tables: vol_InOut (checkin, checkout, location, hour) and vol_data (total_hour). The hour field is used to calculate a particular volunteering hour by day and the total_hour field is the total volunteering hours together.
For this particular volunteer, she volunteered at more than one schools so our calculation is inaccurate. We are looking at this tutorial (http://forums.filemaker.com/posts/be76a023b9) but only want to display particular volunteering hour associated with a school. The tutorial seems to display all data that group by a specific field.
We are wondering if there is other way to accomplish the solution. Any advice is appreciate.