Chart Help

I have a chart I am working on. In the SQL statement area I am working on
trying to get the sum on my chart.

What I have is the ID from the transactions that I have and put them on the
y-axis. I have the week on the x-axis. Here is where I have the problem. I
want to have the actual sum of the tags so that lets say after 10 weeks it
shows 100 total. The problem is that I can not put sum instead of count in
the SQL becasue it would could ID 1+2+3+...etc so you get thousands. Instead
I need to count the 4 in may, the 6 in Joun, the 8 in July etc.

How can I do this or can I? Sum the previous months count plus the current.

Thanks