Hi, I am wondering how other orgs query or report on multiple events.  Going forward next year, we are going to be inputting all of our events in to the Events Module.  However, is there a way to use a query or report to get a total amount raised for every single event?  So, for instance, if we have 30 events per year, how can I get a report or query that shows me the total amount for each event, rather then seeing every gift given to the event?

Currently our events are listed as attributes so when doing a query, every gift given towards a specific event is listed, and then we just fix the excel file.  It's tedious to do that, though, so I'm hoping there's an easier way.   

Thanks so much!

--Jaclyn Hirschorn

I'm sure someone will chime in with a way to do this from within RE, but for now, in Excel, you could add a Group By on the gift attribute that stores the event name. You could also build a pivot table off that data set that would calculate the numbers you're after.

The event summary report provides a total amount given for each event.  You can also determine the type of income - registration fees or event donations so this will be a lot easier than manually sorting in excel!

Best

Charlotte