Something like a running total...

  • 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

  • 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)

  • That's not working, I am trying to do this in a Matrix so it is not recognizing that "cell" as having any data

  • 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:

  • 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

  • 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


    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".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply