I am having a similar problem. I have a database which has firm names, repname, city, state, territory and amount. I am trying to create a pivot table showing that sum of all the reps as well as the the firm, i.e. ABC company has 14 reps and at the same time, there were 42 entries for 14 reps...