Revenue Report

Sheryl Scott
Sheryl Scott
Fourth Anniversary Facilitator 1
in Blackbaud Altru® General Discussions
c12a5ab15bf53666ec888ee02172ca31-huge-sc

How do I combine constituent revenue on a giving report to show as a total donation sum (one line) versus listing each each donation for a constituent. So one total for Sue Smith versus 7 individual donations for Sue Smith. Current setup is shown in the image attached

Tagged:

Comments

  • Taylor Nord
    Taylor Nord
    Third Anniversary Participant Facilitator 1

    Hi Sheryl - I believe you will need to change your query a little to get that SUM information. Here's a screenshot of a query I built that shows the changes you will want to make in the “Results Fields to Display” section.

    b10b80674dfac2a5b61094ba4395e69d-huge-im

    In this section, click the AMOUNT field so it is highlighted, then click the SUMMARIZE button and select SUM from the dropdown selections. This will show the summarized about per Designation reported. If you just want to to know a sum and not per designation, delete the DESIGNATION LIST from the “Results Fields to Display” section.

  • Sheryl Scott
    Sheryl Scott
    Fourth Anniversary Facilitator 1

    After a good night's sleep I figured out the Date field was the problem. Once I removed Date I got a single line item for each constituent. Thank you!

  • Tamara Christensen
    Tamara Christensen
    Ninth Anniversary Kudos 3 Name Dropper Participant

    And you can also make a Smart Field (for example 2021 Giving) and then export that value.

Categories