Hi
What is the best approach for turning the report below into a PivotTable report in SSRS 2008 R2?
The PivotTable has the following characsteristics:
Filters: None
Columns: Mat_Month
Rows: Level1, Level2
Values: MaturingBalances
We have an SSAS Cube with the same data (in a dimensional schema)
The report (currently sourced via SQL from our data warehouse):
The Pivot Table - currently in Excel but needs to be ported to SSRS