I need to report totals by customer and location that includes the name of the largest location for the customer. Can this be accomplished within on custom table?  If so, how would it be done?   

Example: