Log in  ::  Register  ::  Not logged in

 Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Something like a running total... Rate Topic Display Mode Topic Options
Author
 Message
 Posted Monday, November 09, 2009 9:13 AM
 SSC Journeyman Group: General Forum Members Last Login: Thursday, April 04, 2013 2:35 PM Points: 92, Visits: 189
 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
Post #815869
 Posted Monday, November 09, 2009 9:39 AM
 SSC Eights! Group: General Forum Members Last Login: Yesterday @ 3:09 AM Points: 996, Visits: 920
 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)
Post #815904
 Posted Monday, November 09, 2009 2:31 PM
 SSC Journeyman Group: General Forum Members Last Login: Thursday, April 04, 2013 2:35 PM Points: 92, Visits: 189
 That's not working, I am trying to do this in a Matrix so it is not recognizing that "cell" as having any data
Post #816139
 Posted Monday, November 09, 2009 2:45 PM
 SSC Journeyman Group: General Forum Members Last Login: Thursday, April 04, 2013 2:35 PM Points: 92, Visits: 189
 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???
Post #816152
 Posted Tuesday, November 10, 2009 11:50 AM
 SSC Journeyman Group: General Forum Members Last Login: Thursday, April 04, 2013 2:35 PM Points: 92, Visits: 189
 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
Post #816720
 Posted Friday, July 16, 2010 5:33 PM
 SSC-Dedicated Group: General Forum Members Last Login: Today @ 10:49 AM Points: 34,573, Visits: 28,757
 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 Moden"RBAR 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." "Change is inevitable. Change for the better is not." -- 04 August 2013(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013Helpful Links:How to post code problemsHow to post performance problems
Post #954269

 Permissions