Variance on Matrix Report

I was looking for some help with a matrix style report I am trying to
develop.

Example, months accross the top, columns would be product grouping,
then year. The detail would be a summation of invoice value. I can
achieve this no problem. The issue is when I want to get a variance
between the two years, i.e. Jan 2006 vs 2007 as row, underneath each
month.

Any help would be greatly appreciated.

Kaisa
Tue May 15 05:39:58 CDT 2007

Do you want to have the variance as a total for all product groups, or total
for each product group?

I think you can solve it by adding a new row group, and in your details have
a conditional statement like

=iif(InScope("matrix2_Year"),
iif(InScope("matrix2_Month"),
Fields!Measures_Invoice.Value,
SUM(CINT(Fields!Measures_Invoice.Value))),
iif(InScope("matrix2_Month"),
First(Fields!Measures_Invoice.Value, "matrix2_Month") -
Last(Fields!Measures_Invoice.Value, "matrix2_Month"),
"")
)

I usually end up with a test matrix and play around with an expression like
this:

=iif(InScope("rowgroup"),
iif(InScope("colgroup"),
a
b),
iif(InScope("colgroup"),
c,
d)
)

Also, check out where your static group end up. You find this in the Groups
view in the matrix properties. Try changing the order of the column groups
to get the view you want.

When I do funky matrixes, I usually end up spending a lot of time trying and
failing. I think what you want to do is doable, but can't give you a
definitive solution. But try playing around with the InScope function and
conditional formating and column groups and row groups and you'll get it.
With regards,
Kaisa M. Lindahl Lervik

<mark.humphreys@cbg.co.uk> wrote in message
news:1179156042.825867.49470@w5g2000hsg.googlegroups.com...
>I was looking for some help with a matrix style report I am trying to
> develop.
>
> Example, months accross the top, columns would be product grouping,
> then year. The detail would be a summation of invoice value. I can
> achieve this no problem. The issue is when I want to get a variance
> between the two years, i.e. Jan 2006 vs 2007 as row, underneath each
> month.
>
> Any help would be greatly appreciated.
>