Creating View of Customer Totals
I'm trying to figure out how to configure two different views:
1) I'm using Commerce as a means to process donations. What I want to do is create a view that ranks donors based on their total contributions. So if Jim Bob has donated 15 times for a total of $500, I can display his name and his total donation amount. A simple table is all I need but I'm not sure where I would start on the Views end because I am not familiar enough with the various Commerce field options.
2) Similarly, for the user profile where the Orders tab is displayed, I know where to find the View that creates that information, but what I'd like to do is add to the bottom a total donation amount. So if Jim Bob donated 15 times, it will total up all of those donations at the bottom of the view.
I would be very grateful for guidance on either task. I'm fairly comfortable with Views for displaying regular Drupal content/fields but am just not that familiar with Commerce yet.