![]() |
Pivot Table Calculations
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. |
All times are GMT +1. The time now is 12:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com