Max value in Pivot Table



Hi all,

I'm trying to find the maximum value of a column in a pivot table so
that each time the user pivots on a field, it will recalculate the max
value for one of the columns that I can then use in other calculated
fields. Since I'll also be pulling down other fields into the pivot
table, I can't use the MAX function for a specified column letter. Is
this even possible to do? Thanks in advance to any and all replies.

.