I have a tablix with one row group, displaying departments, and initially no column groups but a couple of columns with turnover and cost figures. Therefore it's basically a table, and until so far it works as expected. Now I add an adjacent column group to the table, and in this group I want to show the turnover by product group, so I group this column group on the field "product group". This is displayed correctly, but the problem is that the original columns (that should not have a specific grouping) are multiplied by the number of columns of the group that I added. For example, there are 8 product groups, that means that the turnover in the first column has been multiplied by 8. Basically what I want to accomplish is a tablix with a few general figures not grouped by anything, and adjacent to this a matrix of product groups against the departments. Since the department list is the same, I preferrably don't like to separate this into a table and a matrix. Any help is much appreciated! Thanks.-

Hi, Do you mean you need to accomplish the report as the following table shows? Department Turnover Cost ProductA ProductB ProductC … DeptA 123 456 12 23 34 DeptB 789 123 45 56 78 DeptC 456 789 89 12 23 … If so, please refer to the steps below: 1. Add a matrix to the report. 2. Specify the Department field to the cell which labeled Rows, ProductGroup field to the cell which labeled Columns, Turnover field to the cell which labeled Data. After that, we can preview the report and the turnover is displayed by Department in rows and by product group in columns. 3. In order to add a column without grouped, please right click the handle of the ProductGroup column, and select Insert Column -> Outside group – Left. Then a new static column will be added 4. We can specify the field to the cell in the new static column, and also repeat step 3 and 4 to add another static column. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.