How to show label at the side of expression value in pie chart?

[#1]

Hi,

I have expression as below in pie chart

=Sum(Sales)

I want to show pie chart label at the side of value as in attached. I know to do this using text object. I don't wnt to use text object. Is there any way we can do this with out text object?

Thanks.

[#2]

please see attached.

[robert_mika]

Use Dual function in your expression:

Dual(YourField Name&' - '&Sum (Sales),Sum (Sales))

[#4]

Thanks. I have used below it is not working.

Dual('Salessold'&' - '&Interval(Interval#(Sum(Sales), 'ss'), 'hh'),Interval(Interval#(Sum(Sales), 'ss'), 'hh'))

Sorry actually I forgot to mention. actually my expression is

Interval(Interval#(Sum(Sales), 'ss'), 'hh')

and the label I need to use is Salessold

please help.

[robert_mika]

Take out the  single quote from the Salessold.

Try this

Dual(Salessold &' - '&Interval(Interval#(Sum(Sales), 'ss'), 'hh'),Interval(Interval#(Sum(Sales), 'ss'), 'hh'))

[#6]

Thanks. when  I am trying this it is showing error in expression and bad filed names.

do I need to make  any change

[robert_mika]

Could you attached your file or picture with the error?

[Anonymous]

Hi Amelia,

  You can add you expression in "Text in Chart" option which is available under Presentation tab. So there will not be a external text box needed

-Jay

[#9]

see attached . this I have in another file. The same I need to used with above mentioned Sales column

[#10]

Thanks. I tried this. but I am not getting alignment. I need text in middle at the bottom right corner. would it be possible?