Pivot table Data field question

[Gershon Shamay]

I create a pivot table from three columns of data, using the Wizard.In the
Layout dialogue, I drag one of my fields to the Rows; I drag anther field to
the Columns.
I need to drag a third field to the Data area. There's no conflict there,
each Data cell of the resulting matrix would be unique.
Excel doesn't let me do this. It insists on using a calculation, e.g. Sum of
[field3], Count of [field3], etc.

How do I convince Excel to insert just the value of Field3 in the Data?

 

[Debra Dalgleish]

The field you drag to the data area will always be summarized. However,
if the values are unique, using the Sum function should just display the
values. Are you getting a different result?

I create a pivot table from three columns of data, using the Wizard.In the
Layout dialogue, I drag one of my fields to the Rows; I drag anther field to
the Columns.
I need to drag a third field to the Data area. There's no conflict there,
each Data cell of the resulting matrix would be unique.
Excel doesn't let me do this. It insists on using a calculation, e.g. Sum of
[field3], Count of [field3], etc.

How do I convince Excel to insert just the value of Field3 in the Data?

 

[Gershon Shamay]

The field I want to drag to the data area is ASCII text. None of the
available / allowed formulas work. How can I just drop the field "as is"
without any Excel interpretation?
--

Regards
Gershon Shamay

Area 11L Referee Registrar

The field you drag to the data area will always be summarized. However,
if the values are unique, using the Sum function should just display the
values. Are you getting a different result?

I create a pivot table from three columns of data, using the Wizard.In the
Layout dialogue, I drag one of my fields to the Rows; I drag anther field to
the Columns.
I need to drag a third field to the Data area. There's no conflict there,
each Data cell of the resulting matrix would be unique.
Excel doesn't let me do this. It insists on using a calculation, e.g. Sum of
[field3], Count of [field3], etc.

How do I convince Excel to insert just the value of Field3 in the Data?

 

[Debra Dalgleish]

You can't display text fields as text in the data area. You could add
the field to the row area, where the text will be displayed, then use
another field in the data area to obtain a count of the occurrences.