Hello,

I am creating a matrix report with VS, using drill downs(tree +/-) that
should looks like the following:

START REPORT
+2005
+QTR-1 QTR-2 ...
January February March ...
Tin 10% 25% 80%
Steel 90% 75% 20%
END REPORT

The report should of course calculate properly at each level or the
tree. To do this I simply need to get the sub-total for the group of
Tin and Steel. The problem is I can't seem to find the right report
variable to use. For example, there is the RunningValue variable for
the various matrix groups but they don't get me the sub-total at the
group end of the group; just the total at tin and then Steel. If I had
the total then I could calculate the percentages as above.

The query I use gets me the numbers, correctly, which I then use for
for the calculations. So if some one can let me know how to get the
total of the Tin and Steel group, much appreciated. I can't simply do a
sub-total as this is not a "named variable" like "RunningValue" I can
use in the expression.

Thanks Super Much in advance.