Multi coloured drilldown group

[nareshthavidishetty]

Hi,

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.

Ex: Group=Year+Quarter+Month

Year = red()

Quarter = blue()

Month= yellow()

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.

Thanks..

[nareshthavidishetty]

Hi,

Group name:Year_Cat

Thanks..

[t_chetirbok]

so, you should use

=If(GetCurrentField(Year_Cat)='Year',Red(),If(GetCurrentField(Year_Cat)='Quarter', Blue(),Green()))

[tamilarasu]

Try this

=If(GetCurrentField(Year_Cat)='Year',Red(),

        If(GetCurrentField(Year_Cat)='Quarter', Blue(),

              If(GetCurrentField(Year_Cat)='Month',Green()

                  )

          )

    )

[nareshthavidishetty]

Hi,

Thanks you all .It worked.

=If(GetCurrentField(GroupName)='Year',Red(),If(GetCurrentField(GroupName)='Quarter', Blue(),Green()))

as given by Nagaraj.

Thanks..

[Anonymous]

=If(GetCurrentField(GroupName)='Year',Red(),If(GetCurrentField(GroupName)='Quarter', Blue(),Green()))

[engishfaque]

Dear Naresh,

Here is another efficient way,

=Pick(Match(GetCurrentField(GroupName), 'Year', 'Quarter', 'Month'), Red(), Blue(), Yellow())

Kind regards,

Ishfaque Ahmed