![]() |
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 |
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