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?
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.
|||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.
|||but how to do it if use a table?|||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.
