| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Field in PivotTable
I have a PivotTable in Excel 2003 set up with salesperson name and region
fields in the row area and thier sales totals summed in the data area. Things are working well with that. I am trying to add a calculated field that looks at the region and places one hourly rate for one region and make all the rest display a second rate. It seems as if this could be done with an IF function ( =IF(Region="east",75,65) ) but all results are returned as 65. Can someone help shed some light on this for me? Thanks in advance and have a great day!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated field - pivottable | Excel Discussion (Misc queries) | |||
| #VALUE! in PivotTable using Calculated Field | Excel Discussion (Misc queries) | |||
| Using a field name in an IF function for a calculated field in a PivotTable | Excel Worksheet Functions | |||
| PivotTable:Using a calculated field result in another calculated f | Excel Worksheet Functions | |||
| PivotTable - Calculated Field | Excel Worksheet Functions | |||
Hybrid Mode
