I am currently trying to create formulas in my pivot table to help calculate
a certain field. I am dealing with temperatures and would like to analyze
the calculated data more easily. i currently have a list of Maximum
Temperatures and Minimum Temperatures. When i create the Pivot Table i can
use some of the preconceived formulas such as AVERAGE, SUM, COUNT, etc. but
know i want to take The Average Maximum Value and the Average Minimum Value,
add them together, and divide by two. Basically i know what to find the
Average of the Averages. Can someone please point me in the right direction.