View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Pivot Table Help

Hello,

Thanks for the help with this Pivot Table Question.

In the "Drop Row Field Here" section I am dropping the salespeoples name.
In the "Drop Data Item Here" I am dropping October Sales.

I know to change the table to sum in order to get the total for each
salesperson.

Here is my question:

When I go to drop November sales I cannot figure out how to change the data
from "count" to "sum" and keep October as a "Sum" as well.

Can you help?

Thanks
Jim