#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default pivottable formula

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a PivotTable w/o selecting data in an existing PivotTable Damian Excel Discussion (Misc queries) 6 November 2nd 07 04:44 PM
Excel 2007 - Pivottable formula with COUNT peter Excel Worksheet Functions 2 October 19th 07 10:00 PM
Can I create PivotTable formula using count of field not sum? Clip Excel Discussion (Misc queries) 0 November 7th 06 01:31 AM
Adding formula to PivotTable WLMPilot Excel Worksheet Functions 1 August 7th 06 01:50 PM
pivottable formula : maximum one field - minimum of another one seyhmus Excel Discussion (Misc queries) 1 February 24th 06 12:25 AM


All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"