Expression

[#1]

I have an expression for sum(sales) how to display in the caption such that it shows ''Total sales=sum(sales). in place of sum(sales) i should see the value.

eg: Total Sales = 2012

[Gysbert_Wassenaar · Accepted solution]

Try:  = 'Total Sales = ' & sum(sales)

[rwunderlich]

Do you mean the display in the hover pop-up? What kind of object (chart) do you hve the expression in?

-Rob

[#4]

Hi Gysbert,

Thanks for that. Now it is working

[#5]

Hi Rob ,

I am using Pie chart .

We have different type s of representation for each type of chart? in my case as Gysbert said  = 'Total Sales = ' & sum(sales) is working . Can you please tell me , what if i use different charts

[MayilVahanan]

Hi

For any chart, u can use like this

= 'Total Sales = ' & sum(Sales)

& is used for concat the values

hope it helps

[rwunderlich]

It's the same caption expression for any chart type. I was just trying to clarify if the question was about the caption or hover pop-up.

Don't forget to mark Gysbert's answer correct.

-Rob

[#8]

Hi Mayil,

Thanks for the information.

[#9]

Hi Rob ,

Thanks for the information