AnsweredAssumed Answered

Trailing Subtotal Of Donation Amount By Donor Name in Table View

Question asked by CourtneyTran on Jul 23, 2013
Latest reply on Jul 24, 2013 by CourtneyTran

Title

Trailing Subtotal Of Donation Amount By Donor Name in Table View

Post

     Hi, I have a donor database that I am trying to create summaries for through its table view. I am trying to create a report in table view that shows total donations by donor.

      I went to table view and sorted records by name. Then I went to the "donor amount" field and tried to add trailing subtotals for total donation amount, hoping that the trailing subtotals would appear with totals appearing for each different donor. This did not work. Instead, the trailing subtotals seem to have appeared randomly, totaling everything for one donor at times and sometimes, separating the donations from one donor and totaling them.  It was much like this:

     John Doe: 18.00

Total:  18.00

     John Doe: 10.00

     John Doe: 10.00

Total: 20.00

     ____________________________________________________

     I want it to be like this:

     John Doe: 18.00

     John Doe: 10.00

     John Doe: 10.00

Total: 38.00

Outcomes