Dual Function in expression

[#1]

Hi All,

I have used the dual() function in chart's expression, however, the chart show all the original value in data point not what I want by using dual. Could any one please help to tell why the dual function could not work?

Thanks.

Jelly

[jonathandienst]

With a combo chart, it is possible to make a text-only expression (not a dual) and show this on the data points. Create an expression that returns the text and turn off line, symbol and bar for the expression, then turn on show on data points. I don't think this works for an area chart - but I have never tried.

[timanshu]

Hi Jelly,

Write your expression inside Num().

like..

Num (Dual(If(year =2009,LabelOff,''), count(customer)*100/count(total <year> customer))).

[#4]

Thanks... I have tired and it  could not work..I would like to show text in the chart.