Matrix - Insert column

[V2008]

Matrix - Can I insert a column in middle of few columns.
When I select add column, it always add column at the end of matrix.

 

[jymm]

I have been known to 'fake' a new column or row in a matrix.

essentially when you create a new matrix size the column a bit wide (or tall if you are doing a row). Then CAREFULLY drag TWO Rectangles into the space of the matrix. Then put your two variables in there.

So for example - I had our variable sales year running across the top of the matrix and I wanted Dollars AND the count of the product in each row...

look how this guy does it in Step 4

http://www.simple-talk.com/sql/sql-server-2005/advanced-matrix-reporting-techniques/