reporting services-problem displaying column break in a matrix

[adev111]

Hi there,

I have a matrix in which i want to display data in this manner:

________________________________________________________
|Store | Store1 | Store2 |WEST|Store3| Store4 | EAST |
|-------------------------------------------------------
|#OFprods| 45 | 43 | 88 | 43 | 54 | 97 |
--------------------------------------------------------|Area | 4334 | 3254 |3794| 1000 | 2000 | 1500 |
--------------------------------------------------------



Basically i have a data set returning me the values of "Number of products","Area" based on store and region (west, east). Now its hard for me to bring the TOTAL for a region along with the dataset.

My dataset comes as:

ID |STORE|REGION|Text
45 |store1|WEST | One
43 |store1|WEST | One
43 |store1|East | One
54 |store1|East | One
4334 |store1|WEST | Two
3254 |store1|WEST | Two
1000 |store1|East | Two
2000 |store1|East | Two


Thats why i am adding/averaging number of products or area based on the region.
Now the way i have grouped my matrix is: one row group based on "number of products" or "area" and have a "store" grouping on the column.

Is there any way i can make a break on the column

Or could someone suggest me any alternative other than bringing the value from the dataset.

The reason i am asking for a column break is that if i can break on the columns then i can probably use another dataset to display the region values
Thanks