what are you getting?
If you post some actual grouped data it may help explain.
You may need to bump my suggesstion up to using group level 4 field.
Likely you just need to tweak either of our suggestions to get it to give the correct increment changes. Leave the RT or variables on the canvas and make the changes to see when you get the right combination.
It is hard to tell you what will work without knowing the actual report data and how the grouping is working on this. I am also going under the assumptiont that you always have a 1:1 relationship in group 5 and 6. If not I think there is a logical issue in how you want to color this or I am misunderstanding something about your design and desired output.
Edited by DBlank - 25 Sep 2009 at 12:24pm
IP Logged
