| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivottable formula : maximum one field - minimum of another one
i want to use pivot table for my cycle time calculation. the cycle time is
the difference between the maximum of one column and the minimum of another one. how can i use calculated field? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivottable formula : maximum one field - minimum of another one
A calculated field works with the sums of other fields. You could do the
calculations outside of the pivot table, referencing the cells in the pivot table. seyhmus wrote: i want to use pivot table for my cycle time calculation. the cycle time is the difference between the maximum of one column and the minimum of another one. how can i use calculated field? -- 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 | |||
| How to use built-in Excel functions in PivotTable formula? | Excel Worksheet Functions | |||
| How to type correctly formula in calculated field in a pivot? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Linear Mode
