Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi All,
Coulmn name of heading means The lable of that perticular expression
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
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
Hi Sushil,
you can try this
='total unit processed for' & getfieldselections(operation,';')
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.
Thanks biteguebiessono .... Great example