Converting Excel Pivot Table into Reporting Services
I have a pivot table in excel that looks something like this.
Column1 ValuesHereForColumn1 FilterButtonHere
Column2 ValuesHereForColumn2 FilterButtonHere
Row Labels FilterButtonHere Sum
RowLabel1
100
RowLabel2
200
RowLabel3
300
GrandTotal 600
I have been asked to put it into Reporting Services.
I am new to Reporting Services. Can this be done? I am sure others have been requested to to this. And I was wondering what others have done to accomplish this. I was thinking about maybe using the matrix but I don't know if this
is the right approach.
Can anyone provide help or suggestions?lcerni
February 12th, 2011 9:43pm