Patron Cumulative Spending

Hello!

I'm struggling to find a good way to export the total spending (single tickets, subscriptions, special events, classes, donations) within a given fiscal year for a specific group of constituents.

I'm curious what methods (T-stats, Output Sets, Reports, etc.) folks are using to extract and then compile this information. Ideally the end result would contain the constituent name and ID, spending in each category, and then a grand total for the year.

Any thoughts you have would be appreciated. Thanks!