Help regarding Cyclic Group

[nikhilgarg]

Hello,

I ahve cyclic group having dimensions as : Area Manager and Customer Name

. I want in my chart title, it should show Top 'N' Area Manager or Top 'N' Customer dynamically when i choose area manager or customer from cyclic group.

Plz help

[nikhilgarg]

Hey,

I have space in fieldnames in CyclicGroup. How to resolve that?

Help regarding Cyclic Group

[nikhilgarg]

Hey,

you get my question right. But your suggestion does not seems to work.

[bohravanraj]

Hi Nikhil,

you can use following Code in Text

=if(GetCurrentField(Group)='area manager','N Area Manager',

       if(GetCurrentField(Group)='customer','N Customer'))  

Regards,

[#5]

Let us assume you have like below:

Group Name : Manager Group

Fields: AREA_MANEGER , CUSTOMER

=' Top N' & Pick(Match(GetCurrentField([Manager Group]),'AREA_MANEGER' ,'CUSTOMER'),'Area Manager' , 'Cusomer')

Can you please post your Cyclic Group Name & Field Names in the group so I will provide the correct answer.