Rotate a table in reporting services?

Question

Is it possible to rotate a table in reporting services 2008? If so, how? I'd like to rotate it 90 degrees. Thanks

Answer 1

Use the PIVOT function on the source data before bringing into SSRS.

Example: You have yearly sales data like:

Year Sales

2023	100
2024	120

After a PIVOT, you get:

2023 2024

100

120