pivot table data field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why data in pivot table is different from raw data. On the datafield I chose
"product" not sum or ave....
 
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.
 
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
 
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.
 
Back
Top