pivot tables and averages

O

opeyemi1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
pivot table help 0
pivot table - get the average of a field 1
Month days over a time period 5
AverageIf function with multiple columns 1
Formula within Pivot Table Calculated Field - Days in time period 0
Add AVERAGE column to Pivot Table 0
Pivot Tables - Sum then Average 1

Top