Accessing grouped values "inside" fields

Hello,
I'm struggling to make operations on results obtained from grouping by
specific dimensions. To be more specific, I'd like to substract value of
e.g. sales for some product for one year from values from the preceding
year.
I'd like to somehow access the resulting recordset from grouping and make
some operations on these values, just like the SUBTOTAL function does.
Thanks in advance for any help.
Best wishes,
Marek T³uczekOne correction to my question:
> I'd like to somehow access the resulting recordset from grouping and make
> some operations on these values, just like the SUBTOTAL function does.
I meant not recordset, but set of fields.
> Thanks in advance for any help.
> Best wishes,
> Marek T³uczek
>
>

Access Items Generated in Matrix?

I am using a matrix in a report and it would be great to be able to work with
some of the values it is displaying after they had been grouped and split
apart.
Is it possible to access these values from the matrix somehow?i would look up actions with analysis services. this might be what you're
talking about.
OLAP (analysis services) against OWC allows a flexible, high-performance
reporting solution.
-aaron
"Hunter Hillegas" <HunterHillegas@.discussions.microsoft.com> wrote in
message news:56DC1DA7-0E89-4FA0-821C-775B33B965C2@.microsoft.com...
> I am using a matrix in a report and it would be great to be able to work
with
> some of the values it is displaying after they had been grouped and split
> apart.
> Is it possible to access these values from the matrix somehow?|||Interesting... I will look at it.
Besides this possibility, does anyone know of any other technique that might
be useful here? Is there a way to do something akin to subtotaling but
instead have it show the difference between columns?
"aaron kempf" wrote:
> i would look up actions with analysis services. this might be what you're
> talking about.
> OLAP (analysis services) against OWC allows a flexible, high-performance
> reporting solution.
> -aaron
>
> "Hunter Hillegas" <HunterHillegas@.discussions.microsoft.com> wrote in
> message news:56DC1DA7-0E89-4FA0-821C-775B33B965C2@.microsoft.com...
> > I am using a matrix in a report and it would be great to be able to work
> with
> > some of the values it is displaying after they had been grouped and split
> > apart.
> >
> > Is it possible to access these values from the matrix somehow?
>
>