Substring in chart

[#1]

Hi and sorry for my poor english,

I wonder if there is a way to make a substring for data which are displayed in a Chart,

Example, I have :

dimension	expression
50 - Bla1	448648
100 - Waa2	757454
150 - Aga3	848848
200 - kla4	584854

I use 50-, 100-, 150- and 200- only to sort the dimension used in a bar chart, how can I have only Bla1, Waa2, Aga3 and kla4 displayed in the chart but with the good order ?

Using the XXX - Label pattern works but it's not elegant. (50-, 100-, 150- ... are present in another field)

Thanks in advance.

Christophe

[sunny_talwar · Accepted solution]

May be use the Dual function:

How to use- Dual()

[Anonymous]

you may use subfield in caclulated dimension

e.g. in textobject: =SubField('50 - Bla1', '-', 2) gives you Bla1

[#4]

Wonderful, It works for me ! Thank you!