Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

pivot tables and averages

0 views
Skip to first unread message

opeyemi1 <>

unread,
Feb 16, 2004, 1:51:45 PM2/16/04
to
Hello all,

I have a pivot table as follows: Bill day in Row, Bill Month and
Analyst in Column, with Current Due$ in Data. I want excel to find
the average of the Current Due$ over the months selected and for a
particular analyst on a particular Bill day.

The problem I am having is that I am getting an average of the Current
Due$ on each Bill Day rather than getting an average over the months
selected. Can anyone please help me out? Thanks a million.


Kemi


---
Message posted from http://www.ExcelForum.com/

0 new messages