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_,
Matrix row group=Branch
column group=Month_, invDate