How to use RangeRum and Above

[dotnetfan]

Hello Guys,

Now I'm working on a report, the requirement is to display aggr values for each month and week as following

	July	July	July	July	August	August	August	August
Week Number	27	28	29	30	31	32	33	34
Actual Value	1	2	3	4	5	6	7	8
Aggr value	1	3	5	9	5	11	18	26

Now I used following expression to display values but I don't know how to show it based on week and month:

RangeSum(Above(Sum("Actual Value",0,RowNo()))

Thanks!

Dotnetfan

[sunny_talwar]

Not sure why neither of this work for you

RangeSum(Before(Sum(Value), 0, ColumnNo()))
RangeSum(Above(Sum(Value), 0, RowNo()))

but this worked

Aggr(RangeSum(Above(Sum(Value), 0, RowNo())),"Month","Week")

There might be more then what you provided which might be causing this... but I guess as long as it worked... we should be okay