Pivot table calculated field with max value

[prao]

Is it possible to have a calculated field in a pivot table that uses max value of another field. Currently

Example: I have two columns, avails and spotsused. In the pivot table, I am summing one field and using the max for the other. Can I include a calculated field that shows the 'Sum of Spotsused'/'Max of Avails'.

Thanks in advance.

Praveen

[pre]

'   Max of AVAILS	Sum of SPOTSUSED
AEN	344	        2950

[/pre]

 

[prao]

Forgot to mention - I am using Excel 2007 and will be upgrading to Excel 2010 soon.


Thanks

Praveen