O
opeyemi1
Hello All:
I have a PT designed as follows: Bill Day in row and Bill Month i
column with Average of Amount in data. I want to find the averag
amount of a particular bill day over the months, but when I used th
average of amount, I get a weird number. What the PT table does is t
find the average of each day and then gives the grand total. What
need is for the PT to find the sum for each day and then find th
average of the amounts over the months, i.e. add sum of amount for da
1 for each month and then find the average over the months, if
months, divide by 4.
I hope someone can help me out. Thanks a lot.
Kem
I have a PT designed as follows: Bill Day in row and Bill Month i
column with Average of Amount in data. I want to find the averag
amount of a particular bill day over the months, but when I used th
average of amount, I get a weird number. What the PT table does is t
find the average of each day and then gives the grand total. What
need is for the PT to find the sum for each day and then find th
average of the amounts over the months, i.e. add sum of amount for da
1 for each month and then find the average over the months, if
months, divide by 4.
I hope someone can help me out. Thanks a lot.
Kem