locked
How to create a running total going downward RRS feed

  • Question

  • User1703904260 posted

    Hi

    I am trying to figure out how to create a running total going downward.  I will be using reporting services with a matrix.

    The report is a income statement report.  The level will always be the same and never change.  

    Here's my example

    Jan-16
    Level 2 Code Level 2
    2011 Gross Sales 1000
    2012 Sales Adjustments -159
    Net Sales 841
    2021 Std Cost of Sales -300
    Product Margin  541
    2022 Other Mfg COGS -20
    2023 APA -20
    2024 Distribution -40
    Gross Margin 461
    2050 S,G&A -275
    Operating Income 186
    2081 Other Inc/Expenses -40
    Net Income 146
    Monday, October 31, 2016 4:43 PM

Answers