Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Calculated field item
Hi,
I want to create a calculated field that uses an if to base its calculation results. Therefore i have a field called Site which is a text and another field called materials which is the number of materials. =if(Site="Mexico", materials*300, materials*2000) I have tried this and it doesnt compute based on the Site field or at least the text isnt matching as I have changed the Site to Mexico and it still calculates based on the 2000 amount. Anyone know why? Thanks, Tim |
#2
|
|||
|
|||
Since Site is a text field, the calculated field will evaluate all Sites
as zero. So, materials for all sites will be multiplied by 2000. Perhaps you could add a column to the source data, and do the calculation there, then add the new field to the pivot table. Tim wrote: Hi, I want to create a calculated field that uses an if to base its calculation results. Therefore i have a field called Site which is a text and another field called materials which is the number of materials. =if(Site="Mexico", materials*300, materials*2000) I have tried this and it doesnt compute based on the Site field or at least the text isnt matching as I have changed the Site to Mexico and it still calculates based on the 2000 amount. Anyone know why? Thanks, Tim -- 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 | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
Calculated field in pivot table | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table | Excel Worksheet Functions | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |