View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default 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