9 Replies Latest reply on Jun 13, 2018 12:23 AM by Farhan Quidwai

# Wanted to display sum of numbers in K , M in place for 1000 etc dynamically

Wanted to display sum of numbers in K , M in place for 1000 etc dynamically.

Let say i have a total number of purchase in a day and everyday purchases increases. So i created a measure say sum of car purchase but i wanted to show purchase in K not like 1000 and so on , if the number goes to millions it should display M automatically.

• ###### 2. Re: Wanted to display sum of numbers in K , M in place for 1000 etc dynamically

Not working :-(

• ###### 3. Re: Wanted to display sum of numbers in K , M in place for 1000 etc dynamically

Hi Farhan,

Attach workbook.

Thankssankar

• ###### 4. Re: Wanted to display sum of numbers in K , M in place for 1000 etc dynamically

Hi Farhan,

Thanks,

Mavis

• ###### 5. Re: Wanted to display sum of numbers in K , M in place for 1000 etc dynamically

Hi Mavis ,

Thanks for the reply but i not able to figure it out from your workbook and its not even showing values in K and M in sheet?

• ###### 6. Re: Wanted to display sum of numbers in K , M in place for 1000 etc dynamically

Hi Farhan,

Have you tried hovering over on the tooltips in my previously attached workbook?

:

So the same bar chart, shows both K and M. I've done it on the tooltip rather than a label.

I'll do this step by step so that you can follow.

Create 3 calculated fields

1) Sales L

If

SUM([Sales]) < 1000

Then

SUM([Sales])

End

2) Sales K

If

SUM([Sales]) < 1000000

and

SUM([Sales]) >= 1000

Then

SUM([Sales])

End

3) Sales M

If

SUM([Sales]) >= 1000000

Then

SUM([Sales])

End

Then right click on Sales K and set the default format:

Set it to number custom, no decimal places and with a thousand separator:

Then do the same thing for Sales M but with display units as Millions.

Then add all three fields into label or tooltip and set the tooltip/label to this:

All the fields must be in the same line for the tooltip or label.

Thanks,

Mavis

2 of 2 people found this helpful
• ###### 7. Re: Wanted to display sum of numbers in K , M in place for 1000 etc dynamically

Hey Mavis Thanks alot its working for me

• ###### 8. Re: Wanted to display sum of numbers in K , M in place for 1000 etc dynamically

Hi Farhan,

Fantastic to hear, please mark this thread as being answered so that the status can be updated.

Thanks,

Mavis

• ###### 9. Re: Wanted to display sum of numbers in K , M in place for 1000 etc dynamically

Yes Sure