Subtotal "varieties" -- sql server reporting services

Daniel Edwards
12/2/2004 5:53:02 PM

I am trying to create a matrix report that has
several "subtotals". One subtotal presents the SUM.
Another the AVG. And another the variance to the prior
year. As below:

Jan Feb Mar Total Avg Variance
Prod1 10 20 15 45 15 -8
Prod2 25 10 25 60 20 15
Total 35 30 40 105 35 7

I can obtain each of the "subtotals" individually. I can
even get all of them if i also include all three columns
in each month's detail. but i can not figure out how to
get the various kinds of subtotals in the subtotal level
and NOT also in the detail level.

Any suggestions?

brickmouse
12/3/2004 4:44:18 PM

Hey,

If I understand your problem correctly, you need a way to single out the
SubTotal column.
I so:
Add a column called something like part-total on you dataSet.
part-tatal should be something like GroupMembers / 100 so in a group with
10Members part-Total=0.1 and a group with 4Members part-Total=0.25.

On the Report-Field use an expression like iif(part-Total = 1,......

Marcell.

[quoted text, click to view]

sql server reporting services : Subtotal "varieties"