Hello,

I have a large file that gives me all of the sales for every month from the entire year. My goal is to get the total for the overall accounts and come up with a report to show overall sales numbers.

My problem comes when I do a pivot table to get the data, it will give me all of the individual accounts, but not the overall accounts.
Example:
John Deere-Powertrain
John Deere-Engine
John Deere-Lawn works

I want to see all of these under the main account of John Deere.

I tried using a (left) function to give me similar fields then pivot table from there to get total sales numbers, but the problem is i have accounts like Americorp and Ameritech, so using the left function would combine separate accounts, and if I go out too far, i would revert to problem 1.

Is there an easy way to do this?


Thanks in advance.