toughie? building a chart of some sorts.
Posted on 2004-09-13
hey all, i'm trying to build a chart of some sorts. This is what i want it to look like
month 2004 2003 2002 2001 Average (3)
Jan 42332 43228 9827 8892
i need to have all 12 months in there and also, the count for each year is being pulled from a database that looks like this... Month | Year | Count
so i have to dynamically do this based on my current year. so i have to grab the counts for each month and year, but when we get to september, there won't be a count for 2004 cause the month isn't over. Keep this in mind cause when we go to the average column, we have to average the last 3 years of months. How do i get this going? Thanx a lot!!!!