You're correct. I interpreted the original question as meaning that the
Activity Codes were numeric, and a function other than Sum or Count was
required.

Jim May wrote:
In PT-101 - I think something was said along the lines of:

The Data Area is designed originally and intended to summarize numeric data,
and if non-numeric info is used you can only obtain characteristics like
count and ?? hummmm maybe someting else, not sure what..

If I'm wrong maybe someone can correct me..
TIA,


"Debra Dalgleish" wrote in message
...

If a data field contains blank cells, or cells with text, it defaults to
"Count of".

To change the summary function while in the Pivot Wizard:
Double-click on the data field button, e.g. Count of Activity
Select a different function from the Summarize by list
Click OK

To change the summary function in the Pivot Table:
Double-click on the Data field button, e.g. Count of Activity
(if you have more than one data field, right-click on the
field column heading, and choose Field Settings)
Select a different function from the Summarize by list
Click OK

Randy Harris wrote:

My ignorance of pivot tables is causing me grief, I'd appreciate some
help.
At least I think I should be using a pivot table.

On a worksheet I have a number of rows with 3 columns (Date, Name and
Activity). I'd like to present that data in a pivot table with Name as
the
Row Heading, Date for the Column heading and Activity as the data. The
wizard will only let me put a "Count of Activity" or "Sum of Activity" in
the data field. How do I get it to just put the Activity code there, not
a
count or sum or any other aggregate.

Thanks in advance for any help.




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






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