Monthly Variance

[qcman]

I have two groups (Date, "annually" and System type). I'm using running totals for counts on system by month in a year. For example:
GH#1 2010 JAN FEB MAR
GH#2 AB 5 8 3
CB 4 2 3
DB 6 2 3

GH#1 2011 JAN FEB MAR
GH#2 AB 8 3 5
CB 2 3 4
DB 2 3 6

I want to show the variance per year, per month (Jan(AB) 8 - 5, Feb(AB) 3 - 8 ) etc...

 

[lbass]

You can just use formulas like this:

{#Feb}-{#Jan}

Your running totals should be in the GF#2, not the GH#2, though.

-LB

 

[qcman]

I use that formula for two different months in a year but cannot use it for the same month(name) in different years. My totals are in the footer, that was a typo.

 

[lbass]

Since your outer group is based on year, and your running totals would be reset on change of year, you should be able to use the formula as I suggested. The formula would automatically look at the months within the year.

-LB