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!
I would drag the Total (All Products level) from the cube itself, rather than re-aggregating something that is already aggregated in the cube.