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 |