how to show chart y-axis like Millions and Thousandas?

[#1]

Hi team please find the attached file

How to show Y-AXIS like

1 K

2 K

3 K

4 M

Thanks

[Anonymous]

HI

In Chart Properties ---> Number tab, we have the place to specify symbol for thousand, million, billion.

Regards

Revathy

[sujeetsingh]

Hi,

if you are using Sum(Sales) now to represent it in K and M

--SUM(Sales) &'K'

In logical way u can write

if(SUM(Sales)/100000<100 ,SUM(Sales)&'K','M')  and many more conditions can be mentioned .

Thanks

[#4]

I Know that thing that symbol will come in top ,

but i want to  show 'M' or  'K' Symbol for all values

Thanks

[#5]

ITS NOT WORKING...

[Anonymous]

Hi

Then try while loading itself, Concatenate the field with the symbol required and rename it as another field..

Regards

Revathy

[#7]

hmmm....

[#8]

No answer..

[#9]

hmm..

[#10]

Hi team please find the attached file

How to show Y-AXIS like

1 K

2 K

3 K

4 M

Thanks