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
Maybe it's a version problem Connie; I just used the Pivot Wizard in
XL 2002 and added both an average amp; a sum of the same field without
any problem at all.
Rgds,
ScottO
quot;Conniequot; gt; 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
- Dec 18 Mon 2006 20:34
PivotTable -adding more than one function
close
全站熱搜
留言列表
發表留言