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
Try: = 'Total Sales = ' & sum(sales)
Do you mean the display in the hover pop-up? What kind of object (chart) do you hve the expression in?
Thanks for that. Now it is working
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
For any chart, u can use like this
= 'Total Sales = ' & sum(Sales)
& is used for concat the values
hope it helps
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.
Thanks for the information.
Thanks for the information
Retrieving data ...