ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   PivotTable -adding more than one function (https://www.excelbanter.com/excel-worksheet-functions/64387-pivottable-adding-more-than-one-function.html)

Connie

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

ScottO

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




All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com