Hi, newbie question i'm hoping someone can help me with please?
Ive the following data: -
Region Field Month Value
central Average House Price 1 287222
central Average House Price 2 287234
central Average House Price 3 287333
central Average House Price 4 287653
central Average House Price 5 287786
central Average House Price 6 287897
...and i want to group it like this
Region Field Month1 Month2 Month3 Month4 Month5 Month6
Central Average House Price 287222 287234 287333 287653 287786 287897
How do i go about it in SSRS 2003 please?