Perform aggregate against group value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SevDer - 26 Oct 2005 21:36 GMT

Is there a way that I can perform my aggregate function agains the value in
group row instead of details row?
Because I do not show numeric values in the details but group row.

Signature

SevDer
http://www.sevder.com
A new .NET Source For .NET Developers

Reply to this Message

Robert Bruckner [MSFT] - 27 Oct 2005 03:57 GMT

Did you try the Previous aggregate function? Just place it into the group
header like =Previous(Fields!Country.Value) and it should work. Note: the
previous function has only one argument.

-- Robert

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> Is there a way that I can perform my aggregate function agains the value
> in group row instead of details row?
> Because I do not show numeric values in the details but group row.

Reply to this Message

SevDer - 27 Oct 2005 15:45 GMT

Hi Robert,

I tried Previous as you suggested but this time I endup with empty
datacell..
However, please excuse me that I was not clear enough previously, I want to
perform this aggregate against the group in the footer. So I tried to use
the full previous function as described in the help "Previous(Expression,
AggFunction, PreviousScope, AggScope)" but it basically fails as you've
mentioned.

Anyway, do you have a solution for me?
I would like to sum my group values in the footer.

Signature

SevDer
http://www.sevder.com
A new .NET Source For .NET Developers

> Did you try the Previous aggregate function? Just place it into the group
> header like =Previous(Fields!Country.Value) and it should work. Note: the
[quoted text clipped - 7 lines]
>> in group row instead of details row?
>> Because I do not show numeric values in the details but group row.

Reply to this Message

Robert Bruckner [MSFT] - 31 Oct 2005 00:23 GMT

> I would like to sum my group values in the footer.

Maybe I'm missing something, but assuming you group on
=Fields!FieldName.Value, just adding an expression like
=Sum(Fields!FieldName.Value) in the table footer should sum the group
values.

-- Robert

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi Robert,
>
[quoted text clipped - 20 lines]
>>> in group row instead of details row?
>>> Because I do not show numeric values in the details but group row.

Reply to this Message