For some reason the min and max value are not returning the numbers I need in a pivot table similar to the screen you see below. Trying to get max sales in a period of time.
many thanks!
