Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Running Value on a horizontal row

Author  Topic 

Veda815
Starting Member

5 Posts

Posted - 2010-03-26 : 14:51:02
Can you use running value on a horizontal row?

This is what I am looking for:

Date: April May Jun
Revenue: 100 50 300
Running Total: 100 150 450

I tried both these expressions and both return #error

=runningvalue(Fields!Revenue.Value, SUM, nothing)

=runningvalue(Fields!Revenue.Value, SUM, "Group1") group1 is the group for my months.

Any suggestions?
   

- Advertisement -