View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lear lear is offline
external usenet poster
 
Posts: 3
Default 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.