How to display bar total in bar chart ?

[#1]

Hi,

How to display bar total in bar chart, in bar chart 3 slics is there i want to display total on top of the bar. display millions first after that thousands

please find the attached file.

please help me.

Thanks,

[#2]

If you want to do that you should add your expression in twice, the first expression should be the number in raw format and the option "values on data points" on the presentation tab should be un-checked.

Now, add your expression in again, this time you switch off the "Bar" check box and switch on the "values on data points" check box.

The second expression should be formatted as you wish the number to display on the bar:

If(YourValue>1000000,YourValue & 'M',If(YourValue>1000,YourValue&'K',YourValue))

[Anonymous]

Use the below expression and select invisible optionin the expression tab

=num( sum( revenue) /pow(1000,floor(log10(fabs(sum(revenue)))/3)),'##0.000')

& pick(floor(log10(fabs(sum(revenue)))/3)+1,'',' thousand',' million',' billion',' trillion')

Hope it helps