November 9, 2009 at 9:13 am
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_,
InvBalance
From DailyInventory
Matrix row group=Branch
column group=Month_, invDate
November 9, 2009 at 9:39 am
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)
November 9, 2009 at 2:31 pm
That's not working, I am trying to do this in a Matrix so it is not recognizing that "cell" as having any data
November 9, 2009 at 2:45 pm
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??? :w00t:
November 10, 2009 at 11:50 am
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
July 16, 2010 at 5:33 pm
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 correctly
Hi Marty,
Did you ever get this sorted out?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy