Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to show both percentage ans sum in a block chart. is it possible to achieve the same.?
Thanks
Hi Reena. Yes, it is possible to achieve. You can use Dual function. See attachment.
I dont think have you checked?
Hi Reena,
Yes we can achieve this , please try like this:
=dual('Value:' & sum(Value) & chr(10) & '% = ' & sum(Value)/sum(total Value),sum(Value))
Do *not* format at "Numbers" tab, mark it "Default" format.
Hi Reena. Yes, it is possible to achieve. You can use Dual function. See attachment.