| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statment in a Pivot Table
I'm trying to create a calculated field in a Pivot table that is based on
another field. So, I have something like this: If (field1 = "Y",0,field3/field4) However, this is not working with field1 = Y. Any ideas? -- vcu |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statment in a Pivot Table
The calculated field will use the sum of the referenced fields, so the
sum of a text field will be zero. Perhaps you can do the calculation in the source data, and add that field to the pivot table. vcurban wrote: I'm trying to create a calculated field in a Pivot table that is based on another field. So, I have something like this: If (field1 = "Y",0,field3/field4) However, this is not working with field1 = Y. Any ideas? -- 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 | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Linear Mode
