pivottable formula : maximum one field - minimum of another one

G

Guest

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?
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top