I have a requirement that I am not able to achieve. Would be great if someone can share the experience with similar issues.
I have a drill down Hierarchy group called ProductHierarchy with below structure
Dim 1
Dim 2
Dim3
A
1
x
1
y
1
z
2
l
3
m
B
5
6
7
5
The color sequence is :
Colors:
Red
Green
Blue
Orange
White
Yellow
A block chart is using this hierarchy. The color sequence should be maintained. So the first item at each drill down should always be Red. Second item at each drill down should always be Green etc.