pivot table data field

D

Daniel

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

D. Verdugo

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.
 
D

Daniel

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
 
R

Roger Govier

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.
 
Top