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

Hi , MATRIX is the right option for you. Its similar to Excel Pivot . It definitely suits the Purpose. Try it. Check the Link Below. http://msdn.microsoft.com/en-us/library/ms157334.aspx Hope it helps. Regards, PS Regards, PS

Hi Iceni, Please follow Pritam_Shetty's valuable link, if you have any question, please feel free to ask. Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.