If it appears as "Count of Sales" instead of "Sum of Sales" when you dropped
Sales into the DATA area, probably the Sales figs in your source table are
text numbers (instead of real numbers).

Try this to convert it to real numbers. Copy an empty cell, then right-click
on the Sales col (in the source table) Paste special Add OK. Then try
re-doing the pivot again.

Alternatively, select any cell in the PT that you've done, right-click
Refresh data. Then right-click on "Count of Sales" in the PT Field
Settings. Select "Sum" under "Summarize by" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Desperately seeking hammer !!" wrote:
My first attempt at a PT. I'm nearly there...... When I drop the Sales col
into the pivot table it displays as the total number of entres IE 2 for
Paper. Ideally I need this to display the total of the combined sales of
£40.00.

Thank you for such a speedy reply I am really grateful.

Michelle