convert value of pivot table in million

**Baldev Kumar** · 07-17-2015, 01:47 AM

Hi

I am looking for the option in pivot table for converting the value in millions or Lakh
Please help

**NeedForExcel** · 07-17-2015, 01:59 AM

Why not add a Helper column in the source data that has value in millions or Lakh pre calculated, and then use that in the Pivot Table?

You can also use a Custom Number format #,##0.0,, for Millions

**Baldev Kumar** · 07-17-2015, 02:15 AM

Actually i have a very heavy file with 176000 rows, so i am avoiding to add extra column.

I tried the Custom Number format #,##0.0,, but not able get the result.

i am adding the example sheet.

**NeedForExcel** · 07-17-2015, 02:24 AM

See the file attached..
It is showing in millions

**Baldev Kumar** · 07-17-2015, 02:34 AM

Thanks, for the help. Is it possible for Lakh also?

**Baldev Kumar** · 07-17-2015, 04:07 AM

found the Custom Number format for Lakh
0.##,,,"Ctrl+J"%%

convert value of pivot table in million

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

convert value of pivot table in million

Re: convert value of pivot table in million

Re: convert value of pivot table in million

Re: convert value of pivot table in million

Re: convert value of pivot table in million

Re: convert value of pivot table in million

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] UDF required to convert number with k to Thousand and with m to Million

Convert a Matrix into a List. Can I use Pivot Table for that?

Convert Table for Better Pivot Usage

Convert Values by Million

How do i convert row array into one column using pivot table

Convert Pivot Table to Normal Data table

Pivot Table - How Do I Convert Data?

Bookmarks

Bookmarks

Posting Permissions