Dynamically Change the Expression Label

[#1]

All,

Good Day...

I am making a pivot table with 3 dimension and 2 expression.

The dimension are

Customer Code

Customer Name

Air Line

The Expression are

Amount

Incentive

I want an option to dynamically change the name of this Incentive based on the dimension Airline, if the air line is A, then i need

Incentive as "Incentive -10%", if the Airline is B, incentive should be "Incentive-20%" and go on..

Appreciate your help

Thanks

RK

[MK_QSL]

Is there any on AirLine selected at a time?

If Yes, you can use something like below in lable

=If(GetFieldSelections([Air Line]) = 'A', 'Incentive -10%', 'Incentive - 20%')

[jsingh71]

Please share some sample data then will try to implement this.

[#4]

No, I cannot select a particular Airline. Need to make it dynamic..

[#5]

Hi,

i have attached a sample file. Please have a look on that.

[#6]

I have attached a sample file..

[buzzy996]

Hi Ranjith, we have to tell the system/ur chart some way u changed some thing(accordingly ur changes ur chart expressions also will change),but ur saying to MRKachhiaIMP question answer as NO,if that is the case how ur system will understand something is dynamically changed?

u can use the option suggested by MRKachhiaIMP

else u can create a variable with input box,and pass ur values as Airline A or B, and in ur expression u can us ethis variable and write ur conditions.

[#8]

Okay Shiva,

Let me try like that...