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:
|Level 1||Level 2||Level 3||Level 4 (product Code)|
|Level 1||RBG Color for level 1|
|Level 2||RBG Color for level 2|
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