| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you create formulas in pivot table eg simple division?
I am trying to divide one field with another inside the pivot table.
There are formula options (% of base field and base item) within the field settings but these are not what I am looking for. Is there another way to create calculations inside the pivot table. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you create formulas in pivot table eg simple division?
You can create a calculated field --
Select a cell in the pivot table On the pivot table toolbar, choose PivotTable Formulas Calculated Field Type a name for the formula, and enter your formula, e.g.: = TotalSales / Units Click OK Belinda_Tim wrote: I am trying to divide one field with another inside the pivot table. There are formula options (% of base field and base item) within the field settings but these are not what I am looking for. Is there another way to create calculations inside the pivot table. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you create formulas in pivot table eg simple division?
Thanks!
"Debra Dalgleish" wrote: You can create a calculated field -- Select a cell in the pivot table On the pivot table toolbar, choose PivotTable Formulas Calculated Field Type a name for the formula, and enter your formula, e.g.: = TotalSales / Units Click OK Belinda_Tim wrote: I am trying to divide one field with another inside the pivot table. There are formula options (% of base field and base item) within the field settings but these are not what I am looking for. Is there another way to create calculations inside the pivot table. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table vs. Formulas | Excel Worksheet Functions | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
Linear Mode
