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

In excel 2003 by right clicking on the field name or its data in the pivot
table and then selecting 'Field Settings' a dialogue window appears that
allows selection of how the data is displayed for that field in the pivot
table data area...

Are you able to do this?

Or is it something more complicated? - at the end of you mail you indicate
there might be...

--
If this is the answer you hoped for please remember to click the yes button
below...

Kind regards

Rik


"Jim" wrote:

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