May 16, 2008 at 3:18 am
Hi,
I have a dataset result as given below.
Year Sales Discount Taxes
----- ----- -------- ------
2001 100 25 15
2002 200 20 15
2003 150 15 12
2004 160 25 16
I want the SSRS table to display output as
2001 2002 2003 2004
---- ---- ---- ----
Sales 100 200 150 160
Discount 25 20 15 12
Taxes 15 15 12 16
Please let me know if some has tried or some has idea on this
Thanks in Advance
May 16, 2008 at 5:48 am
Use a Matrix to pivot your data on the years and add three rows to the detail section of the matrix, one for each of your columns.
May 16, 2008 at 6:03 am
Thanks for your reply.
I tried the same and found that the columns added in detail part of matrix table were reflecting under each year as columns.
Let me know if u have any advice on this
May 16, 2008 at 6:25 am
Because you have the data semi-pivoted already, you will have to go in and manually modify the groupings in the matrix. The default layout will not work.
May 16, 2008 at 6:33 am
Can u pl help in letting me know what r the manual changes to be made?
Thanks in Advance
Giri
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply