how to change column name dynamically??

[sushil353]

Hi All,

I want to change a coulmn name in a straight table chart type in such a way that when ever i make a selection in a field the coulmn name sould change accordingly..   

for example..

In a chart i am calculating a coulmn as  sum(total_unit_processed) and there is field called operation in which various operation like X,Y,Z are there..

If i select X then sum(total_unit_processed) is calculated for X operation.

Now i want to name this coulmn like when X is selected then heading of coulmn should be total unit processed for X  and if i select then the heading should be total unit processed for Y.....

please help me out....

Thanks

[sushil353]

Hi All,

Coulmn name of heading means The lable of that perticular expression

[lironbaram · Accepted solution]

hei

you can try something in the lines of

='total unit Processed for ' & concat(OpeartionField,',')

that way it will show you all the fields availble in the operation field

[its_anandrjs]

Hi Sushil,

You also able to fetch by this code ='total unit Processed for ' & concat(getcurrentselections(OperatedField,',')

By this you get field value, hope this helps you.

Regards,

Anand

[#5]

Hi Sushil,

you can try this

='total unit processed for' & getfieldselections(operation,';')

[#6]

Hi Sushil,

Try the following:

First, go to Settings, then 'Variable Overview' to create a variable such as :

vOperation  =Operation .

U can now go back to your straight table chart where u calculate your sum(total_unit_processed): On the label

type in this expression: =if(Operation='$(vOperation)',Operation,'total_unit_processed'). I have a test:

Regards.

[sushil353]

Thanks biteguebiessono .... Great example