Pivot Table - how to show Average Mvt Time

Hi,

I'm sure this has been asked a dozen times, but because I'm not sure how to explain what I want, I can't find the answers anywhere.

In Pivot Tables can you (how do you) make one column a calculation of another. e.g.

columns: Mvt-Type | No-Of-Mvts | MVT-Duration | Average-Time-Per-MVT

I can do the first 3 easily, but I can't work out how to make the calculation "avg_time_per_mvt"

Thanks In Advance

Just being dumb - realised that it was possible to do with "sumamrise values by" -> AVERAGE