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
Solved! Go to Solution.
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
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.