I am trying to write a summary report for how much buy from each of my suppliers.  My suppliers my have multiple locations so they will appear individually. I want to accumulate all my purchases under one name regardless of the location.   So for example a supplier may appear as Nucor Decatur and Nucor Berkley.  I would want to group all purchases under the Nucor group.  Can this be done?