Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like my Pie Chart to simultaneously show me the count of values, and what % that count makes of the overall Pie Chart. At the moment, all I can get is one or the other.
Thanks
Daniel
Hello, you can go to the presentation tab and add a new "text in chart" expression to either display % or count. This will create an extra label, apart of what is shown in the chart already.
Regards
Hi Daniel,
try DUAL function, like this:
Dual(
Num(Sum(sales)/Sum(Total sale),'0.00%') & chr(13) & Num(Sum(sales),'#,##0'),
Sum(sales)
)
with flag "values on data points"
Alex