Dynamic label change at expression where dimension is a Drill down group

[Anonymous]

Hi,

I have a bar chart in which i am using a drill down group as dimension. Group comprises of 2 calculated fields

1. A calculation that brings an Year

2. a calculation that gives the name .

So these two fields make this dimension group .

Now in my expression I want to use Label which changes on basis of Year.

Eg. for

year 2013 :   Text pop up(Label) should look like        Year =2013

                                                           Actual = 70%

      2014                                             Year = 2014

                                                          Actual/Forecast=78%

    2015                                              Year=2015

                                                          Forecast=89%

So as stated ,here Label changes dynamically on basis of year and year comes from the Dimension Group.

How to make these Label dynamic

Please revert it asap.

Thanks,

Vijit

[francoiscave]

Hi Vijit,

You can use this functions :

getcurrentfield (GroupName)

and Concat(distinct Field,',')

François

[Anonymous]

My group name is : Planned Year-Month

And formula in Label expression :

This is not working for me .Check it once

[francoiscave]

Vijit,

Can you send an application with a simple example.

It would be better to correct your formula.

Thanks,

François

[PradeepReddy]

Try something like this

IF(GetCurrentfield("Planned Year-Month")='Projected vs Plan.Year',

    IF([Projected vs Plan.Year]='2013','Actual'))

[Anonymous]

This is not working Pradeep.

[Gabriel]

Hi,

Please upload same data, if possible with the APP.

Best Regards,

Gabriel