Prev: Calculate finance charges
Next: Workbook Size Increases dramatically
From: Krystal Peters on 30 Nov 2009 16:30
I have the below daily data grouped by month. I have the actual total
transmitted and suppressed records. Using the same fields I have the daily
avg transmitted and suppressed records. Days is the count of day in each
month (excludeing weekends).

See data below:

Avg Dly Avg Dly
Date Trnsmttd Suppressed Trnsmttd Suppressed Days

Jul 97,282 65,811 6,080 5,062 16
Aug 125,339 126,538 6,267 6,327 20
Sep 129,856 109,692 6,184 5,223 21
Oct 136,805 151,396 5,948 6,582 23
Nov 121,597 97,509 6,400 5,132 25
Total 610,879 550,946 6,170 5,739 105

What I want to do in this pivottable is to multiply the Avg Daily Suppressed
by the Days to equal a possible monthly average. How can I get a pivottable
formula to calculate this?

Thanks, Krystal K. Peters
 | 
Pages: 1
Prev: Calculate finance charges
Next: Workbook Size Increases dramatically