## Something like a running total...

 Author Message marty.seed SSCommitted Group: General Forum Members Points: 1855 Visits: 216 Hello!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_, invDate Nick_UK SSCommitted Group: General Forum Members Points: 1804 Visits: 1233 Could 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) marty.seed SSCommitted Group: General Forum Members Points: 1855 Visits: 216 That's not working, I am trying to do this in a Matrix so it is not recognizing that "cell" as having any data marty.seed SSCommitted Group: General Forum Members Points: 1855 Visits: 216 We 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??? marty.seed SSCommitted Group: General Forum Members Points: 1855 Visits: 216 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 Jeff Moden SSC Guru Group: General Forum Members Points: 796853 Visits: 45952 marty.seed (11/10/2009)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 correctlyHi Marty,Did you ever get this sorted out? --Jeff ModenRBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair Helpful Links:How to post code problemsHow to post performance problemsForum FAQs