Cycle Group Issue

[NavinReddy]

Hi Community

I have one cycle group like Line of business(LOB)

if i select LOB in cycle group two fields should be added in stright table(SubLob1,SubLob2)

could some one help me

Plz Find The Attachment

Thanks,

Niranjan

[NavinReddy]

Guys any idea

Urgent.........

[#3]

Hi Niranjan,

=

IF(GetCurrentField

(cyclic group name)='Line of Business',1,0)

use this expression in to  condition ,

GetCurrentField(cyclic group name)  will return the selected dimention in the cyclic group.

Thanks & Regards

Khemraj

[#4]

Hi,

Add the calculated dimension like below.

=if(GetCurrentField(cgChart)='Line of Business',SubLob1)

=if(GetCurrentField(cgChart)='Line of Business',SubLob2)

Regards,

Kabilan K.