Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PivotTable -adding more than one function
I am trying to enter both an average of sales revenue by month and a total of
sales revenue by month. I can't seem to be able to do both. I can either do the sum or average or minimum, etc, but I can't seem to put in more than one. -- Connie Rose |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PivotTable -adding more than one function
Maybe it's a version problem Connie; I just used the Pivot Wizard in
XL 2002 and added both an average & a sum of the same field without any problem at all. Rgds, ScottO "Connie" wrote in message ... | I am trying to enter both an average of sales revenue by month and a total of | sales revenue by month. I can't seem to be able to do both. I can either do | the sum or average or minimum, etc, but I can't seem to put in more than one. | -- | Connie Rose |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
Adding superscript in text function | Excel Worksheet Functions | |||
Adding a Macro to a VLookup Function | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Need Function for adding rows on multiple sheets... struggling rookie ;) Thanks. | Excel Worksheet Functions |