Hi
i need a suggestion on how to color some expressions but with a drill-down dimension. Here is the situation:
I have 4 Product dimensions (from the leaf to the highest aggregation), and i have created a drop-down group.
Now I need to assign a colour to each value of each dimension. For example:
Drill-down Group:
| Level 1 | Level 2 | Level 3 | Level 4 (product Code) |
|---|
| A | A1 | AA1 | 1 |
| A | A2 | AA2 | 2 |
| B | B1 | BB1 | 3 |
| B | B2 | BB2 | 4 |
| Level 1 | RBG Color for level 1 |
|---|
| A | RGB |
| B | RGB |
| Level 2 | RBG Color for level 2 |
|---|
| A1 | RGB |
| A2 | RGB |
| B1 | RGB |
| B2 | RGB |
and so on for the 3 level.
In my chart i need the colors to vary according to the dimesion of teh drill-down and to the value of the dimension.
How can i do this?
tx in advance
