Subtotal of Pivot "Max" calculation problem
 

I have locations with multiple records and I am filtering my Values to only
show the Max. When I create a subtotal of the values, it shows the total of
all records, not just the total of the max of each location.

Any ideas?

Thanks