if this is more than 1 year of data try this:
Here is a sample of my data
Number user minutes
month
123456 tom 1234
month 2
tom 6543
month3
tom 4521
123456 tom xxxx
these total are monthly sums from my database. Month, month 2, etc is a group.
What I want to is in my number group total ( is have xxxx to be the avg of my monthly sums.
Hope this helps. If I can give you a screen shot it might help illustrate.
NO. It is a calc in CR that I did for each month for each person. I want to avg the monthly totals.
IP Logged
