How to show values like 50m ,40k on chart bars?

[#1]

How to show values like 50m ,40k on chart bars?

please find the attached doc

thanks.

apps

[#2]

in my case iam using chatr type as staked ..

if with out stacked its working ffine.

i want stacked case scenoireo...

[#3]

thats not for stacked style chatrs..

[#4]

any body help on this

[rustyfishbones]

Are you looking for something like this

If so, let me know and I will attach the qvw

[Anonymous]

use this expression   simple expresion like sum(revenue ) use below expresion

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

& pick(floor(log10(fabs(sum(revenue)))/3)+1,'',' K',' M',' B',' T')

and in the style  Select Stacked

hope this helps

Have a nice Day

[#7]

I WANT TO SHOW TOTAL ON ABOVE LIKE

[rustyfishbones]

Ok

Add an Expression summing up all other Expression, untick Bar and Click show values on Data Points

This will show the Total amount on the Stacked Bar, then just add the IF statement from the earlier post to that expression, here is a pic of what I mean

[#9]

its not working

i used two dimensions

1.country

2 category

expression:

if

(sum(Revenue)>=1000000,
num(sum(Revenue)/1000000,'#,##0.0 M'),
num(sum(Revenue

)/1000,'#,##0 K'))

[rustyfishbones]

You need to send me some of your sample data

otherwise this will never get solved

[#11]

Please help on above problem