how to stop cells from adding together on a pivot table?
 

Using seperate worksheets- when creating my pivot table, there is more than
one client with the same name and different amounts, why is the pivot table
adding these figures together?

how to stop cells from adding together on a pivot table?
 

A pivot table summarizes items that are the same. Maybe there's a client
number you could add to the pivot table, to differentiate the clients,
and that will keep the amounts separate.

Wigged out wrote:
Using seperate worksheets- when creating my pivot table, there is more than
one client with the same name and different amounts, why is the pivot table
adding these figures together?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html