We have created an drill down group with 3-fields and created an bar chart.
Now we need to coloured 3-dimensions with in group dynamically based on selection.
Year = red()
Quarter = blue()
We have used '=If(GetCurrentField(Group) = 'Period', Red(), Blue()) ' this logic but it works for 2-fields with in a group.If we add another colour the logic won't work.
try to check the name of your fields and group name
and post your example, please
sorry i can't share an application.
Scenario: My drill down group has 3-dimensions
Chart used: Bar
Requirement: Year = red,quarter=blue,moth=green.
Current result after using '=If(GetCurrentField(GroupName)='Year',Red(),If(GetCurrentField(GroupName)='Quarter', Blue(),Green()))'
Not able to capture month=green