Multicolour for drilldown dimensione

[Anonymous]

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