Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Excel 2007 - Pivottable formula with COUNT | Excel Worksheet Functions | |||
Can I create PivotTable formula using count of field not sum? | Excel Discussion (Misc queries) | |||
Adding formula to PivotTable | Excel Worksheet Functions | |||
pivottable formula : maximum one field - minimum of another one | Excel Discussion (Misc queries) |