| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot calculated field not summing correctly
I created a calculated field "A" in a pivot table with the formula=if(hours ge 1,1,0) where hours is another data field. At the detail level it populates the calculated field properly. However, the totals and subtotals show up as 1.
[note: had to use the ge rather than greater than operator in if statement above because it was getting dropped everytime I previewed the post] thx cgc |
| 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 | |||
| How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
| Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
| How to type correctly formula in calculated field in a pivot? | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Linear Mode
