pivot table data field
 

Why data in pivot table is different from raw data. On the datafield I chose
"product" not sum or ave....

pivot table data field
 

If you put it in the "row labels" field, you should be able to have it
display as raw data. The values is meant for calculation of the data.

"Daniel" wrote:

Why data in pivot table is different from raw data. On the datafield I chose
"product" not sum or ave....

pivot table data field
 

Hi D. Verdugo
But I can not see the "row lables" field. After right click on pivot table/
field setting/
pivot table field dropdown table/ sumarize field. I see sum, ave, product,
stdev....
Thanks
Daniel

"D. Verdugo" wrote:

If you put it in the "row labels" field, you should be able to have it
display as raw data. The values is meant for calculation of the data.

"Daniel" wrote:

Why data in pivot table is different from raw data. On the datafield I chose
"product" not sum or ave....

pivot table data field
 

Hi Daniel

Try dragging the filed twice from the Field list.
Once to the row area, and the second time to the Data area.
Double click on the filed in the Data area to select what Numerical
analysis you require.
--
Regards

Roger Govier


"Daniel" wrote in message
...
Hi D. Verdugo
But I can not see the "row lables" field. After right click on pivot
table/
field setting/
pivot table field dropdown table/ sumarize field. I see sum, ave,
product,
stdev....
Thanks
Daniel

"D. Verdugo" wrote:

If you put it in the "row labels" field, you should be able to have
it
display as raw data. The values is meant for calculation of the data.

"Daniel" wrote:

Why data in pivot table is different from raw data. On the
datafield I chose
"product" not sum or ave....