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
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