Your email address will not be published. Required fields are marked *

  1. If you group 2 fields in a pivot table, the resulting value is added. In other words if you group two items say 1 and 2, the result is 3. Is there any way to have the max value in that group returned. In other words 2?