8 Replies Latest reply on Jul 24, 2013 12:43 PM by CourtneyTran

    Trailing Subtotal Of Donation Amount By Donor Name in Table View

    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