SQLServerCentral / Reporting Services / Reporting Services / Something like a running total... / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 21:16:13 GMT20RE: Something like a running total...http://www.sqlservercentral.com/Forums/Topic815869-150-1.aspx[quote][b]marty.seed (11/10/2009)[/b][hr]I figured out how to do it for the weekly total rows...=iif(InScope("Date2"), sum(Fields!Sales.Value), last(Fields!Sales.Value))Now the conundrum lies in trying to total the total columns correctly[/quote]Hi Marty,Did you ever get this sorted out?Fri, 16 Jul 2010 17:33:51 GMTJeff ModenRE: Something like a running total...http://www.sqlservercentral.com/Forums/Topic815869-150-1.aspxI figured out how to do it for the weekly total rows...=iif(InScope("Date2"), sum(Fields!Sales.Value), last(Fields!Sales.Value))Now the conundrum lies in trying to total the total columns correctlyTue, 10 Nov 2009 11:50:51 GMTmarty.seedRE: Something like a running total...http://www.sqlservercentral.com/Forums/Topic815869-150-1.aspxWe are definitely on the right track here, I need to find the value for the max(date) and pass it to the "Total" cell...now how to do this??? :w00t:Mon, 09 Nov 2009 14:45:51 GMTmarty.seedRE: Something like a running total...http://www.sqlservercentral.com/Forums/Topic815869-150-1.aspxThat's not working, I am trying to do this in a Matrix so it is not recognizing that "cell" as having any dataMon, 09 Nov 2009 14:31:07 GMTmarty.seedRE: Something like a running total...http://www.sqlservercentral.com/Forums/Topic815869-150-1.aspxCould you do a sum on the values where the invdate equals the max invdate within the month grouping, something along the lines of,SUM(IIF(invdate = MAX(invdate,"Month"),InvBalance,0)Mon, 09 Nov 2009 09:39:55 GMTNick_UKSomething like a running total...http://www.sqlservercentral.com/Forums/Topic815869-150-1.aspxHello!I am tracking our company's inventory in a SSRS 2008 Tablix report. I am displaying the inventory for each day, at the end of the Month I need to display the Month inventory...basically the inventory on the last day of the month. Select invDate, Branch, Month(invdate) as Month_,InvBalanceFrom DailyInventoryMatrix row group=Branchcolumn group=Month_, invDateMon, 09 Nov 2009 09:13:18 GMTmarty.seed