Matrix Column Trouble

I am trying to add an ungrouped columns to the end of a matrix. in RS SP2 2000

For example how do I add the three columns in red to a matrix in a report

	Q1	Q2	Q3	Total	Percentage	Turn Over Ratio	Budget Variance
Sales	100.00	100.00	100.00	300.00	100%	1.23	4.22
Cost	100.00	100.00	100.00	300.00	100%	1.23	4.22
Expense	100.00	100.00	100.00	300.00	100%	1.23	4.22

Steve Peacock

Thanks for the response... That is what I was afraid of, that I wouldn't be able to do this, it's just not one column that I will need to add but many. I guess I'll have to try and get something like you are describing thanks for you help. I hope somone else will respond that has had this type of issue as well.
wargy2

I had an instance where I wanted a total and then an average of the data in a matrix, however I was not able to figure it out. I hope someone answers, but I was unsuccessful in adding anything other than 1 subtotal.

I ended up using a table next to the matrix to display the avg. It took a bit to line it up properly but it works fine. Just a suggestion if you dont get a positive response.
EVH
but how to do it if use a table
cjpa15

I was finally able to do it without a table. but one matrix. I did this by adding a fake groups, Expression=1, Expression=2, Expression=3.

Then using the InScope function to determine where I was at on the different subtotals.

If anyone wants to know send me an email at jwisener@gmail.com

I just have one more problem and that is to figure out how to get rid of the white space above the matrix. Because I have to add a padding to the subtotal top to get the header to move down to the same line as the rest of the headers.
Matrix Column Trouble