K
Krystal Peters
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
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