cancel
Showing results for 
Search instead for 
Did you mean: 

Display all the values in Million (M) pivot

praveenpaul03
8 - Cloud Apps
8 - Cloud Apps

Is there any way to show all the values in millions even if data is in thousands, the default million formattings will show the values less that a million in the regular format

 

praveenpaul03_0-1663002561046.png

 

 

 

2 REPLIES 2

Angelina
9 - Travel Pro
9 - Travel Pro

Hi @praveenpaul03,
You can use custom currency format.
Just devide your value by 1 000 000 in the formula and add Symbol M.
Below is an example with thousands.

Angelina_0-1663058954832.png

Best regards,
Angelina

 

 

harikm007
12 - Data Integration
12 - Data Integration

Hi @praveenpaul03 ,

You can also use below script (if you are using pivot2):

const myTarget = {
type: ['value'],
values: [
{
title:[ 'Value to Million'] // put here desired column
}
]
};


widget.transformPivot(myTarget, function(metadata, cell) {
	cell.content = (cell.value/1000000).toFixed(2) + 'M'
});

harikm007_0-1663059355931.png

-Hari