| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated field in pivot adds row
I have a pivot table and I would like to create some calculated fields as
columns, but I am only able to add rows within the pivot table. Any suggestions on how to overcome this? Thanks all. Brennan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculated field in pivot adds row
After you add the calculated field, in the pivot table, drag the Data
button to the right, into the cell that contains the word Total. There's a picture he http://www.contextures.com/xlPivot02.html Brennan wrote: I have a pivot table and I would like to create some calculated fields as columns, but I am only able to add rows within the pivot table. Any suggestions on how to overcome this? Thanks all. Brennan -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Item in Pivot Table Adds Rows with Zero Values | Excel Discussion (Misc queries) | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Linear Mode
