Data Field in Pivot Table is Non-numeric

[Guest]

The data field of my pivot table is non-numeric and hence it is shown as '0' when Sum or Average is selected as the summarization option. I know that there will be only a single value for each cell in the data area of the pivot table and hence do not require summarization. How do I show the value (non-numeric) instead of showing a summarization

Copy of the source data and the resultant pivot table are shown below

Regards

R. Ven
Kochi Refineries Limite
Indi

Source Data

Sample Property Time Valu
CV17 Naphtha Density 01/15/04 8:00 >.783
CV17 Naphtha Density 01/15/04 16:00 >.746
CV17 Naphtha Density 01/16/04 0:00 >.756
CV17 Naphtha IBP 01/15/04 8:00 12
CV17 Naphtha IBP 01/15/04 16:00 13
CV17 Naphtha IBP 01/16/04 0:00 14
Heavy Naphtha Flash 01/15/04 8:00 >4
Heavy Naphtha Flash 01/15/04 16:00 3
Heavy Naphtha Flash 01/16/04 0:00 2
ATF Density 01/15/04 8:00 0.78
ATF Density 01/15/04 16:00 0.77
ATF Density 01/16/04 0:00 0.79
ATF Flash 01/15/04 8:00 4
ATF Flash 01/15/04 16:00 3
ATF Flash 01/16/04 0:00 >5

Pivot Table

Sum of Value Property
Sample Time Density Flash IB
ATF 01/15/04 8:00 0.789 48
01/15/04 16:00 0.779 38
01/16/04 0:00 0.796 0
CV17 Naphtha 01/15/04 8:00 0 12
01/15/04 16:00 0 13
01/16/04 0:00 0 14
Heavy Naphtha 01/15/04 8:00 0
01/15/04 16:00 34
01/16/04 0:00 23

 

[Dave Peterson]

The only way you can use Text values in the data field is Count.

Can you make your field another row or column field.

If you double click on it and choose to show no totals, then it might look like
it's part of the key.

===
I don't use access, but I think Debra Dalgleish posted that Access handles text
in its Cross tables. (but that could be wildly inaccurate!)

 

[Debra Dalgleish]

In Access, you can show data in Crosstab queries, by using the First or
Last functions (you were pretty close!)

 

[Dave Peterson]

Woohoo!

Today, I'm an Access expert. Yesterday, I couldn't spell it.

 

[Debra Dalgleish]

You spelled 'it' correctly. Tomorrow, you can try something with three
letters.

Woohoo!

Today, I'm an Access expert. Yesterday, I couldn't spell it.

 

[Dave Peterson]

It's pretty lucky you used spellcheck--now that would have been embarrassing.

(This was the cleaned up version of my response--my original did include one 3
letter word and a couple with one letter more!)

hehehe!

You spelled 'it' correctly. Tomorrow, you can try something with three
letters.

<<snipped>>