phanh

Create subtotal reports

Discussion created by phanh on Jan 6, 2014
Latest reply on Jan 7, 2014 by BruceHerbach

Hello, everyone

 

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.

 

Screen Shot 2014-01-06 at 8.16.14 AM.png

 

Screen Shot 2014-01-06 at 8.16.33 AM.png

 

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.

 

 


Outcomes