Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Formula in Pivot Table for 2003 and 2007-how?
I don't know if I should finish the week right now because I'm pathetic at
trying to solve this problem. Here goes: 1) I want to edit a formula that I have created in my Pivot Table and I can't see where that is possible. 2) I have my list and I have created a Pivot Table. 3) I have a column with my expenses. 4) I created a formula which says "=expenses*10%" 5) It works fine. 6) I want to be able to edit the formula to 20% but I can't see where I can edit the formula. 7) It seems like my only option os to delete it and create one with 20%. 8) I have tried this with Excel 2003 and 2007 and both are the same. Is it possible to edit the existing formula? If anyone has the answer, I would be very appreciative. If not, I'm calling it a week :) Thanks for any assistance in advance! Jugglertwo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Formula in Pivot Table for 2003 and 2007-how?
Did you create a calculated item or a calculated field?
If it's a calculated field, you'll see its name in the field list. To change it, select a cell in the pivot table On the PivotTable toolbar, click PivotTableFormulasCalculated Field. Select the field's name from the dropdown list Change the formula, then click OK If it's a calculated item, you won't see its name in the field list. To change it, in the pivot table, select a heading cell for the item On the PivotTable toolbar, click PivotTableFormulasCalculated Item. Select the item's name from the dropdown list Change the formula, then click OK Jugglertwo wrote: I don't know if I should finish the week right now because I'm pathetic at trying to solve this problem. Here goes: 1) I want to edit a formula that I have created in my Pivot Table and I can't see where that is possible. 2) I have my list and I have created a Pivot Table. 3) I have a column with my expenses. 4) I created a formula which says "=expenses*10%" 5) It works fine. 6) I want to be able to edit the formula to 20% but I can't see where I can edit the formula. 7) It seems like my only option os to delete it and create one with 20%. 8) I have tried this with Excel 2003 and 2007 and both are the same. Is it possible to edit the existing formula? If anyone has the answer, I would be very appreciative. If not, I'm calling it a week :) Thanks for any assistance in advance! Jugglertwo -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Formula in Pivot Table for 2003 and 2007-how?
Debra:
You made my day ! I spent over two hours trying to get an answer. I never noticed the dropdown arrow. You are the bestest :) Thanks ! I owe you one. Jugglertwo "Debra Dalgleish" wrote: Did you create a calculated item or a calculated field? If it's a calculated field, you'll see its name in the field list. To change it, select a cell in the pivot table On the PivotTable toolbar, click PivotTableFormulasCalculated Field. Select the field's name from the dropdown list Change the formula, then click OK If it's a calculated item, you won't see its name in the field list. To change it, in the pivot table, select a heading cell for the item On the PivotTable toolbar, click PivotTableFormulasCalculated Item. Select the item's name from the dropdown list Change the formula, then click OK Jugglertwo wrote: I don't know if I should finish the week right now because I'm pathetic at trying to solve this problem. Here goes: 1) I want to edit a formula that I have created in my Pivot Table and I can't see where that is possible. 2) I have my list and I have created a Pivot Table. 3) I have a column with my expenses. 4) I created a formula which says "=expenses*10%" 5) It works fine. 6) I want to be able to edit the formula to 20% but I can't see where I can edit the formula. 7) It seems like my only option os to delete it and create one with 20%. 8) I have tried this with Excel 2003 and 2007 and both are the same. Is it possible to edit the existing formula? If anyone has the answer, I would be very appreciative. If not, I'm calling it a week :) Thanks for any assistance in advance! Jugglertwo -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Formula in Pivot Table for 2003 and 2007-how?
You're welcome, and thanks for letting me know how it helped.
Jugglertwo wrote: Debra: You made my day ! I spent over two hours trying to get an answer. I never noticed the dropdown arrow. You are the bestest :) Thanks ! I owe you one. Jugglertwo "Debra Dalgleish" wrote: Did you create a calculated item or a calculated field? If it's a calculated field, you'll see its name in the field list. To change it, select a cell in the pivot table On the PivotTable toolbar, click PivotTableFormulasCalculated Field. Select the field's name from the dropdown list Change the formula, then click OK If it's a calculated item, you won't see its name in the field list. To change it, in the pivot table, select a heading cell for the item On the PivotTable toolbar, click PivotTableFormulasCalculated Item. Select the item's name from the dropdown list Change the formula, then click OK Jugglertwo wrote: I don't know if I should finish the week right now because I'm pathetic at trying to solve this problem. Here goes: 1) I want to edit a formula that I have created in my Pivot Table and I can't see where that is possible. 2) I have my list and I have created a Pivot Table. 3) I have a column with my expenses. 4) I created a formula which says "=expenses*10%" 5) It works fine. 6) I want to be able to edit the formula to 20% but I can't see where I can edit the formula. 7) It seems like my only option os to delete it and create one with 20%. 8) I have tried this with Excel 2003 and 2007 and both are the same. Is it possible to edit the existing formula? If anyone has the answer, I would be very appreciative. If not, I'm calling it a week :) Thanks for any assistance in advance! Jugglertwo -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grouping error in Excel 2003/2007 Pivot table connect to offline c | Excel Worksheet Functions | |||
Excel 2007 pivot chart/table copying vs Excel 2003 | Charts and Charting in Excel | |||
Excel 2007 pivot table formats that work with 2003 | Excel Discussion (Misc queries) | |||
Pivot table from 2003 to 2007 | Excel Discussion (Misc queries) | |||
Excel 2003 view formula within pivot table | Excel Worksheet Functions |