| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table data field
Why data in pivot table is different from raw data. On the datafield I chose
"product" not sum or ave.... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Filtering Data Field | Excel Discussion (Misc queries) | |||
| use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
| use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
| Pivot Table Field Data | Excel Worksheet Functions | |||
| Pivot Table Data Field Query | Excel Worksheet Functions | |||
Linear Mode
