Crosstab with additional text fields on rows

[ReportWriter]

Hello,

I have a problem creating a crosstab with additional text fields on rows. I'm using a cube, where I have Product dimension, and now I should categorize these products into categories.

I have created a crosstab where product categories are added with 'Crosstab Space (with Text)', and then products are dragged one by one under each category. How I can aggregate the totals. I don't need subtotals for Product Categories, but total of all products. Also I need Margin % to be calculated correctly (weighted %).

It should look like this:

                                | Net Sales | Margin | Margin % |
Product Category A
product 1
product 2
product 3
Product Category B
product 4
product 5
product 6
TOTAL                          |     100     |  50     | 50 %      |

I would appreciate if someone has done this before and could give a hint how to solve this. Thanks!

[rockytopmark]

I would drag the Total (All Products level) from the cube itself, rather than re-aggregating something that is already aggregated in the cube.