I need to create a report in SSRS that would display data by YEAR. Because I do not know the fixed years, I am creating this report using matrix (pivot) so years are dynamically created as a column.
What I need the report to look like: I want the report to do a cumulative add per year at row level.
Assume:
- GAAP Revenue for 2017 for Lease Assumption Key '20300' = $100.
- GAAP Revenue for 2018 for Lease Assumption Key '20300' = $120.
- GAAP Revenue for 2019 for Lease Assumption Key '20300' = $150.
Based on Assumption:
- I want 2017 GAAP Revenue for Lease Assumption Key 20300 to display = $100.
- I want 2018 GAAP Revenue for Lease Assumption Key 20300 to display = $220.
- I want 2018 GAAP Revenue for Lease Assumption Key 20300 to display = $370.
Similar should happen to "Cash Revenue" rows.
Is this possible in SSRS? If not, how would I go about doing this in SQL Server 2008r2?
Here's what I've done so far in SSRS:
RunningValue
function. Try this=RunningValue(Fields!GAAPRevenue.Value, SUM,"datasetname")
- SS_DBA