Pivot table Data field question

  • Thread starter Thread starter Gershon Shamay
  • Start date Start date
G

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?
 
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?

Gershon said:
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?
Click to expand...
 
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
Debra Dalgleish said:
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?

Gershon said:
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?
Click to expand...
Click to expand...
 
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.
 
Back
Top